Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Finding the next empty line

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

    Default

    No luck with that, but thx.

    If I specify rr = 5 (i.e. row 5) then find the next empty line after row 5 but before the next available data which is on row 25. Can we do it this way?

  2. #12

    Join Date
    May 2002
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you only need to check column A for blank cells starting at A5 :-

    Sub insert_flow()
    [A5:A65536].SpecialCells(xlCellTypeBlanks)(1, 1).Formula = "=NOW()"
    End Sub


    [ This Message was edited by: dwhj on 2002-05-08 01:09 ]

  3. #13
    Board Regular
    Join Date
    Mar 2002
    Posts
    160
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    FANTASTIC - thank you!

Some videos you may like

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
  •