+ Reply to Thread
Results 1 to 2 of 2

next empty row

  1. #1
    ASU
    Guest

    next empty row

    Can anyone help. I use a userform which users fill in to enter data on a
    worksheet (sheet2). The rows that are used is between "C10" to "C19". How can
    I write a code that will find the next empty row between C10 and C19.
    --
    ASU

  2. #2
    Don Guillett
    Guest

    Re: next empty row

    how about

    mynextrow=cells(10,"c").end(xldown).row+1

    --
    Don Guillett
    SalesAid Software
    [email protected]
    "ASU" <[email protected]> wrote in message
    news:[email protected]...
    > Can anyone help. I use a userform which users fill in to enter data on a
    > worksheet (sheet2). The rows that are used is between "C10" to "C19". How
    > can
    > I write a code that will find the next empty row between C10 and C19.
    > --
    > ASU




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1