Excel VBA to fill down from Variable named cell to Last Row
Posted on 2011-09-13
I have a workbook that I want to automate some actions.
Each Month the initial coluimn of data will be added to the right of the prior data using
lastRow = Range("A" & Rows.Count).End(xlUp).Row
After this I use a Vlookup function to get data from another book with:
Set rngFound = ActiveCell
ActiveCell.FormulaR1C1 = _
Here is my question, I need to go to the cell named "rngFound" and fill down (the Vlookup) in that column to (variable=) lastRow.
-I need to keep the range dynamic to allow for continual unmonitored automation.
Can somebody help me with the AutoFill Code??