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

next empty row
 

how about

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

--
Don Guillett
SalesAid Software

"ASU" wrote in message
...
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