Hi

Rows("1:" & Lastrow).Select

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"dabith " skrev i en meddelelse
...
Hey all

another question

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


---
Message posted from http://www.ExcelForum.com/