Retrieves first empty row in an Excel sheet.

by Rone (9 Submissions)
Category: Miscellaneous
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Fri 14^th May 2004
Date Added: Mon 8^th February 2021
Rating: (1 Votes)

Rate Retrieves first empty row in an Excel sheet.



    Dim rngBlankCell As Range

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

Download this snippet Add to My Saved Code

Retrieves first empty row in an Excel sheet. Comments

No comments have been posted about Retrieves first empty row in an Excel sheet.. Why not be the first to post a comment about Retrieves first empty row in an Excel sheet..

Retrieves first empty row in an Excel sheet.

Retrieves first empty row in an Excel sheet. Comments

Post your comment

Difficulty