Thread: Finding Row
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett
 
Posts: n/a
Default Finding Row

next
nr=cells(activecell.row,activecell.column).end(xld own).row+1
or better yet
lr=cells(rows.count,activecell.column).end(xlup).r ow+1

--
Don Guillett
SalesAid Software

"fak119" wrote in message
...
Is there an easy way (Macro) to go to the next empty row or column?