I need a code to fetch the row number of first blank cell in a column.
dim i as integer
While Sheets(5).Cells(i, 2) <> ""
i = i + 1
MsgBox i 'num of the blank line
Thanks to Polux31 for this tip.
Published by jak58
Latest update on March 26, 2013 at 10:24 AM by jak58.