Hello - I have a macro that determines the last populated row in a region and fills down the formula to the last row. It works awesomely unless there is only ONE row populated, in which case it copies down the row above. Here is the code:[INDENT]
Dim LastRow As Long
LastRow = Cells(Cells.Rows.Count, "C").End(xlUp).Row
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-1],Key!C[-4]:C[-3],2,FALSE)"
Range("O14:O" & LastRow).FillDown
I have this code for multiple columns, etc, but they're all using the same "fill down" information.
I'm one of those "create a macro by recording it, then edit it" people and I'm slowly teaching myself how to write it, but not there yet. Any help would be greatly appreciated!