Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do within an If statement
Hi, Tom Ogilvy gave me the following code, which works great. the
problem i have is that as it loops down it must check if the ActiveCell is empty, if yes then do the Vlookup, if not then move one cell down to the next empty cell. My spreadsheet has +/- 5000 rows but must only apply the Vlookup to the empty cells in column X. Range("X1").Select Do ActiveCell.FormulaR1C1 = _ "=VLOOKUP(RC[-23],LCS_Complete_E90.xls!C1:C12,2,0)" ActiveCell.NumberFormat = "dd-mmm-yy" activeCell.Offset(1,0).Select Loop until isempty(activecell.offset(0,-23)) Could somebody please help me out of my misary ? Tempy *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions |