AUTOFILL / COPY & PASTE HELP
Posted by Jon on January 01, 2001 7:13 AM
Being very new to VBA I hope someone can help me with this little problem.
I am developing a text file cleaner and adding a VLOOKUP to Lookup some simple data .
My file varies in row length which is where my problem arises.
I insert a blank column and then enter my VLOOKUP formula. Now what I want to do is copy and paste this formula down the entire row length.
I recorded this and the recorded marco only selects the exact range of the original file I use
Here is a code snippet:
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC,'Cell ID.xls'!ID,2,FALSE)"
Now I know I could probably change the range so that it references the entire worksheet but that is not what I want.
I want is to find the last non-blank row in Column A and then copy and paste my formula in Col C from c2 to the final row number.
I hope I make sense!!
Anyone any ideas?