Programming

Code not working
I need to capture the Last Row number as soon as the WB opens; And as the sheet2 Column A cells are filled-in have the variable Lrow furnish an up-to-date value, representing the last non-blank row in Col A of Sheet2. The below is not working; Can yo suggest a better way? TIA, Dim Lrow As Long Private Su... 16 Mar 2010 16:17

Simplifying an If(OR(…)) statement
Is there a way to do the following without using if(OR(…, …, …, …., …)) for each of 100 cells? I have a column of 100 cells each containing a number from 1 through 10. If the number 7 is greater than any of the 100 cell’s I want it to say “yes”, otherwise “no”.. Example: if(or(7>A1, 7>A2, 7>A3, …, 7>A100), “... 17 Mar 2010 09:07

Auto Populate a Template
I know very little about VBA and the only way I have created Macros is by having Excel follow my mouse and Recording the Macro, then modifying the reults as needed. Here is what I've been asked to do: I have a spread sheet with several columns of data in various formats. Each time a row of data is added, that d... 18 Mar 2010 20:07

macro pointing to wrong folder
We use a macro that is stored in the "personal" file in the XLSTART folder of the local drive. A new employee wanted the macro, so I copied it to his folder on the network drive and installed it on his local drive and it works fine, however, my macros now look to his folder on the network drive whenever I try to r... 16 Mar 2010 15:07

Multiple row insertion on various worksheets
Need to be able to add row to Sheet1, and at the same time add a row to Sheet2 at a certain off sett row. Then if possible populate both new row with what is in the row above in the same way as would occur using the autofill pull down. Thanks Shaun ... 16 Mar 2010 11:25

pdf file in a UserForm
Is there a way to insert a .pdf file in a UserForm and be able to scroll through the pages? ... 16 Mar 2010 11:25

How well does MS Office 2003 run on Windows Server 2008, IN PRACTICE ?
Question: What does your experience have to do with the Office 2003 and Server 2008? a a r o n . k e m p f @ g m a i l . c o m wrote: I used Office 2002 on Vista for about a dozen machines for the past 15 months without too much trouble On Mar 15, 8:16 am, "Peter Foldes" <ok...(a)hotmai... 16 Mar 2010 10:16

List Listbox items in column by macro
Hi all, I got two listboxes on a spreadsheet and in those listboxes I got data like (see below) Listbox1 Listbox2 XX AA VV XX AA SS etc……….. I need macro on a button which should match listbox1 items with listbox2 items and then list matched items one time... 16 Mar 2010 04:41

Get Range object from Cell Row and Column No.
Hi, I'm using Excel 2003, I have a function which I want it to return a range object which points to a cell, the cell is identified by the code which determins which column number and row number make up the Cells RowIndex and ColumnIndex attributes. For some reason I keep receiving an application-defined or... 16 Mar 2010 03:33

User Account
How can I determine if a user is logged in as an Administrator or as a standard user without Admin priveleges ... 16 Mar 2010 10:16