MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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