Hi All,
Would anyone know how to search for the "First Empty Row" in a VB Macro?
And if possible, can this be copied into a variable (maybe called: FirstEmptyRow) in the format of: $A$31 (for Row 31) or $A$99 (for Row 99), for example?
(The reason for this, is because I would like to make a macro that would search for the first unused row, then append C:\append.csv to that particular row, in column A)
Thanks so much,
CG