Results 1 to 2 of 2

Thread: Find next empty row and select Columns A to D
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Sep 2019
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Find next empty row and select Columns A to D

    Hi,

    I am trying to find a code which will select the next available empty row down the spreadsheet and then select columns A to D of that row.

    Could anyone help me out with this please?

    Many thanks

  2. #2
    Board Regular
    Join Date
    Sep 2016
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Find next empty row and select Columns A to D

    If you mean the row after the last row with data :
    Cells(Cells.Find(What:="*", After:=Cells(1), SearchOrder:=xlByRows, _
    SearchDirection:=xlPrevious).Row + 1, 1).Resize(, 4).Select


Some videos you may like

User Tag List

Tags for this Thread

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
  •