Next Row
 

I'm trying to find the code which automatically finds the next available row
in excel in order to paste some data from the clipboard. Please could you
help?

'next available row' can be interpreted/defined in various ways. What
criteria would *you* use to determine availablity?

If it's the cell below the last filled cell in column A

dim rng as range
set rng = cells(65536,1).End(xlup).offset(1.0).entirerow


"Neil" wrote:

I'm trying to find the code which automatically finds the next available row
in excel in order to paste some data from the clipboard. Please could you
help?

try
nextavailrow=cells(activecell.row,activecell.colum n).end(xldown).row+1
or this might be better
lastrow=cells(rows.count,activecell.column).end(xl up).row+1
--
Don Guillett
SalesAid Software

"Neil" wrote in message
...
I'm trying to find the code which automatically finds the next available
row
in excel in order to paste some data from the clipboard. Please could you
help?