Copy the new line...

Posted by Victor Graham on March 11, 2001 4:05 PM

Hi
I'm trying to write a Macro that will copy the last line (16 cols wide) of
data in a file that grows by one line with every save, and then paste the
data in a specific cell in a different sheet. I'm far from at home with this
stuff and would appreciate any help, advice or answers that I can get.
Especially if I understand them!
Thanks

Victor

Posted by Dave Hawley on March 11, 2001 4:26 PM

..
.

Hi Victor

This will do it! Just alter the ranges to suit. If you have any questions, just yell!

Sub TryThis()
Dim LastCell As Range
Set LastCell = Sheets("Sheet1").Range("A65536").End(xlUp)
LastCell.Resize(1, 16).Copy _
Destination:=Sheets("Sheet2").Range("A1")
Application.CutCopyMode = False
End Sub

Dave

OzGrid Business Applications