Select All Rows Between Two Rows in VBA

[BetterBeef]

Hello.

I want to be able to select rows 33 through rows 37 in VBA. I tried using the Union function, but this only selected rows 33 and 37. I want to select 33, 37, and everything in between. Is there a function that allows me to do this?

I want to do the equivalent of selecting row 33 with my mouse, holding the shift button down, and selecting row 37.

Any thoughts?

 

[VoG]

Try

Rows(33 & ":" & 37).Select

but you should not need to select them in order to work with them.

 

[Tom Urtis]

Why not
Rows("33:37").Select

 

[VoG]

Why not
Rows("33:37").Select

Why not indeed

However, if they were variable and not hard coded then

Rows(i & ":" & j).Select

 

[Tom Urtis]

Yes, if

Actually I should be working on my projects and minding my own business but was curious for the ampersands when it looked like a hard coded question, which maybe it really isn't.

 

[BetterBeef]

That may have worked, but what I forgot to mention is that I am using two variables in the formula. Here is my formula:

report.Rows(SalesmanRow - LoopCount&":"&SalesmanRow - 1).Select

What am I doing wrong?

SalesmanRow is an Integer
LoopCount is an Integer

These are being set by a loop that I am running.

 

[BetterBeef]

OK, I figured out my problem. It always helps to actually have spaces between ampersands and variables. When I did that the code worked great! Thanks for your help!