rows(argument)

dabith · #1 (**permalink**) June 13th, 2004, 05:23 AM

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

Birger · #2 (**permalink**) June 13th, 2004, 06:05 AM

Is this what you seek:

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

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

dabith · #3 (**permalink**) June 13th, 2004, 06:13 AM

yep thanks for that

Need to download code?

Navigation