Programming

Assign a range to where the User Form places data
I have a user form with several text boxes and list boxes. I am having difficulties getting the data to be put in the right range. It goes to the next unused line and uses that line, however, there are couple lines at top of spreadsheet, so it uses those, instead of starting on line 4 as I would like. I have... 22 Dec 2009 18:11

How to find the owner of the active excel workbook
Dear Smart People, I'm sure this has been asked before but I'm not able to find the answer. In Visual Basic, how may I find the name or system ID of the owner of the currently active workbook? I apologize if this is an "old" question but I've not been able to gleen the answer. Thank you! Janet ... 23 Dec 2009 13:59

Range created using Union...accessing cells
In trying to use the ranges created from Union, I can't refer to the cells properly. For example, R1=Union(myrange1, myrange2) If I try the following it works fine: Dim c as range For each c in R1.Cells msgbox c.Address Next If I try the following the second iteration when I=2 gives me the address of ... 22 Dec 2009 23:44

Identifying a Pivot Table
How can I tell in code, I the current tab contains a pivot table. Actually, I need the code for Access, But if I can see the code in an Excel Macro I can translate it to Access VBA. (Hopefully) Thanks -- Shell ... 22 Dec 2009 18:11

Convert uppercase to lowercase
Does anyone have a bit of code to convert a file of conatcts all in UPPERCASE to Lower Case? ... 22 Dec 2009 14:50

updating with now()
Using 2003. I have a work sheet, at the bottom I have "Updated" and in the next cell I simply put in =Now(). This brings up the date and time each time I open. Now what I want to do is see when I last opened and updated. How can I do this ... 22 Dec 2009 12:37

How to set the column title in a listbox from Excel
any help here? ... 22 Dec 2009 10:23

VBA to count periods in a single cell
I am looking to count the number of periods within a single cell using vba. For instance if I have 4 cells that contain the following: 5M09-0000700.01.10 5M09-0000700.01.10.10 5M09-0000700.01.10.10.10 5M09-0000700.01.10.10.20 Thus the output of the code for the first cell should be '2', the second cell ou... 22 Dec 2009 15:57

If cell value is greater than another cell value, clear contents.
Okay, hopefully this is the last question today! I've found the below formula in one of the posts here, but my brain has completely failed on me and I'm not sure how to adapt it to my requirements. I have a value which is entered by the user after a prompt, that populates in cell G4 in a sheet called 'Lookup'... 22 Dec 2009 09:15

Excel Macro: insert formula into first blank cell in column &
Mike H, Thank you so much, it works perfectly. I probably should have included the formula, but it was fairly simple so not difficult to add to your example. Many thanks! "Mike H" wrote: Hi, It would have helped if you had told us the formula! Try this Sub FillUp() Dim lastrowA As Long... 22 Dec 2009 08:09