Hide Multiple Rows

[Partjob]

Hi Everybody
I seem to have a simple problem but can't get it right.
I am trying to hide Rows with multiple ranges.
I recorded this to see how to structure such a statement.

Range("7:12,22:28").EntireRow.Hidden = True

This works obviously however the following doesn't and I don't understand why.

Sheet6.Range(StrRowP & ":" & 38,StrRowC & ":" & 280,StrRowE & ":" & 408).EntireRow.Hidden = True

Can you list multiple ranges like this or because I have varibles in the range do I have to write them individually. Could you also please explain what rules I have to follow for such a situation.

Thanks for the help
Partjob

 

[Jonmo1]

Look Very Carefully at how your range string is being built.

Try

Sheet6.Range(StrRowP & ":38, " & StrRowC & ":280, " & StrRowE & ":408").EntireRow.Hidden = True

 

[Partjob]

Jonmo
Thanks a lot, just to clarify, I must enclose all parts of the string in inverted commas including the commas that seperate the ranges themselves, but excluding the varables. I take it this would be the same for any multiple range string?
I would never have guessed that.
Thanks
Partjob

 

[Jonmo1]

Just keep in mind that you're building the command using concatenate.

combining text strings with variables.

The TEXT STRINGS should be within Quotes. The VARIABLES Should NOT be in quotes.

Example

Variable1 = 75
Variable2 = 38

I want my formula to read
=IF(A38=A75,100,0)

to build that i use
Range("a1").Formula = "=IF(A" & Variable2 & "=A" & Variable1 & ",100,0)"

"=IF(A" <---This is the first Text String (surrounded by quotes)
& Variable2 <---Concatenates Variable 2
& "=A" <---Concatenates the next text string "=A" (surrounded by quotes)
& Variable1 <----Concatenates Variable 1
& ",100,0)" <---Concatenages the last text string ",100,0)" (surrounded by quotes)

 

[Partjob]

Jonmo
Great explaination and I do understand, the clues were there really in the bit I recorded, I just did not see them. I have also built formulas in the very way you have just explained but did not associate that with what I was trying to do.

all the best

Partjob