Copy with a macro

[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

 

[Don Guillett Excel MVP]

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 -

change
NextRow = .Cells(88, "A").End(xlUp).Row + 1
to
NextRow = .Cells(1, "A").End(xldown).Row + 1