Consulting

Results 1 to 2 of 2

Thread: RowNext starting from a certain Row

  1. #1
    VBAX Expert
    Joined
    Apr 2007
    Location
    Orlando, FL
    Posts
    751
    Location

    RowNext starting from a certain Row

    I have this code.
    RowNext = ws.Cells(ws.Rows.Count, 1).End(xlUp).Row + 2
    It works good, but Since it puts data every 2 rows, i need to tell it to start looking at row 5 down.
    So if data is in Row 4, to put the data in Row 5 not Row 6, then jump to Row 7 and so on.

    I am pretty sure it's something easy.

  2. #2
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    So if data is in Row 4, to put the data in Row 5 not Row 6, then jump to Row 7 and so on.
    Say What?

    RowNext = ws.Cells(ws.Rows.Count, 1).End(xlUp).Row + 2 
    If RowNext < 5 Then RowNext = 5
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

Posting Permissions

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