• Home
 · 
• Miscellaneous
 · 
• Retrieves first empty row in an Excel sheet.

Retrieves first empty row in an Excel sheet.

Retrieves first empty row in an Excel sheet.

Rate Retrieves first empty row in an Excel sheet.

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

    Dim rngBlankCell As Range

    'Determine the last row
    Set rngBlankCell = Sheets("Categories").Columns(1)
    intBlankRow = rngBlankCell.Find("", Range(strCatIDCol & strStartRow)).Row