rows(argument)
Hey all
Hoping someone can help a newbie to vba
how do I use the Lastrow variable in the Rows argument???
Dim Lastrow As Long
With ActiveSheet
Lastrow = .UsedRange.Rows.Count + .UsedRange.Cells(1).Row - 1
Rows("1:Lastrow").Select
Selection.Copy
Thanks
|