Select next empty row
Eliminate Pivot Table Annoyances
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Select next empty row

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Would anyone be kind enough to tell me what code I would need to use to simply have cell (Column A Row next empty row ) selected and ready for user input.

    I have 10 rows of heading at the top then add new data each day after the previous entry.Would like to be able to click macro button that would take me to this cell.

    Thanks in advance.
    Joe.

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Try the following:

    Set BlankCells = Columns("A").SpecialCells(xlCellTypeBlanks)
    BlankCells(1).Select

    Its not great, but it works.
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com