View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gaba gaba is offline
external usenet poster
 
Posts: 83
Default find last row in another worksheet

Hi everybody,
I need to copy data from one sheet (active sheet) to another, say
"printdata". I need to find the next empty row in column A of "printdata" and
paste the information there. My problem is the active sheet will be changing
all the time but the destination is always the same sheet. How can I refer to
the last row in printdata without leaving the active sheet?
--
gaba :)