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

Do I simply enter this last line into any Macro?

"Don Guillett" wrote:

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?