Copy with a macro

  • Thread starter Thread starter pcor
  • Start date Start date
P

pcor

This works fine.....but I dare ask for a small improvement. Is there a
way
the the program could find the next empty line in block a and palce
the info
there.
Thanks
Ian M
----- Original Message -----
From: "Dave Peterson" <[email protected]>
Newsgroups: microsoft.public.excel.programming
Sent: Friday, July 23, 2010 1:01 PM
Subject: Re: Macro to copy
 
This works fine.....but I dare ask for a small improvement. Is there a
way
the the program could find the next empty line in block a and palce
the info
there.
Thanks
Ian M



----- Original Message -----
From: "Dave Peterson" <[email protected]>
Newsgroups: microsoft.public.excel.programming
Sent: Friday, July 23, 2010 1:01 PM
Subject: Re: Macro to copy












- Show quoted text -
Click to expand...
change
NextRow = .Cells(88, "A").End(xlUp).Row + 1
to
NextRow = .Cells(1, "A").End(xldown).Row + 1
 
Back
Top