MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copy the new line...

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

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!


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 _
Application.CutCopyMode = False
End Sub


OzGrid Business Applications