Variable Syntax Error

[specs]

Dim rowStart As Integer
Dim rowEnd As Integer

rowStart = 2
rowEnd = 5

Rows.("rowStart:rowEnd").Select

Can someone help me out with the Rows.("rowStart:rowEnd")
im getting an error for that part.

 

[Norie]

Does this work?

Dim rowStart As Integer
Dim rowEnd As Integer

rowStart = 2
rowEnd = 5

Rows(rowStart & ":" & rowEnd).Select

By the way why are you selecting a range? You don't actually need to select/activate ranges etc to work with them.

 

[specs]

Great it works. Thanks Norie.

By the way why are you selecting a range? You don't actually need to select/activate ranges etc to work with them.

The select is just an example. it supposed to be .Copy