Problem with ROWS in VBA

[madkinson]

I am trying to write some VBA that will reference two variables, however I get a run-time error when I debug.

Here is the code:

Rows("StartRow:EndRow-1").Select

where Dim StartRow As Integer
and Dim EndRow As Integer

For example, when I run my subroutine, it assigns a value of 2 to StartRow and 4 to EndRow. I can see this in my Locals window. What am I doing wrong?

p.s. I apologize for not posting the entire code, but the IT staff don't let me download any add-ons

 

[VoG]

Remove the "

Why do you need to Select?

 

[Joe4]

Anything you enclose in quotes in treated as literal text, not variables. Try:

Rows(StartRow & ":" & EndRow-1).Select

 

[madkinson]

The goal of the rest of the code is to hide the selected rows.

 

[Richard Schollar]

Hi

Your code is being interpreted as text where it falls between the double quotes:

Rows("StartRow:EndRow-1").Select

everything in bold is being seen as text when Excel tries to run the code. What you want to do is have Excel see your variables, therefore they need to be not surrounded by quotes as Vog indicated:

Rows(StartRow & ":" & EndRow-1).Select

Best regards

Richard

 

[VoG]

Rows(StartRow & ":" & EndRow-1).Hidden = True

better

 

[Scott Huish]

Also, when dealing with row numbers in variables, it's better to use the Long data type since the amount of rows available in Excel exceeds the range of the Integer data type.

 

[Smitty]

p.s. I apologize for not posting the entire code, but the IT staff don't let me download any add-ons

You can enclose your code in HTML Code tags.

"["code"]" Code Here "["/code"]"

No quotes.

HTH,

Smitty

 

[madkinson]

THANKS!! You guys really bailed me out. It worked perfectly.