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

Is this what you seek:

Range("A1:A" & Lastrow).Select

..provided you only want to select data from column A

yep thanks for that