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.
This document, titled « Excel/VBA - Get the row number of the first blank cell », is available under the Creative Commons
license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM