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
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks