Insert Cell text in formula VBA

[barqujo]

Hello everyone,

I have this formula

ActiveSheet.Rows("8:8").Hidden = True

I want to extract the "8:8" from a cell (let's say A1) in the worksheet that contains "8:8" so it would look like this

ActiveSheet.Rows(Range("A1")).Hidden = True

Anyone knows the correct form to write that??

Thank you!!!

[ragulduy]

Please Login or Register  to view this content.

[barqujo]

Thank you for your response yudlugar!

However I've tried that and unfortunately does not work!

[ragulduy]

It works for me providing the contents of A1 are actually 8:8 as text (i.e. I typed '8:8 into the cell not just 8:8)
what happens if you run this macro (what comes up in the messagebox):

Please Login or Register  to view this content.

[shyamhappy]

Can you please try this

Activesheet.Rows(Range("A1").Value).hidden = true

[barqujo]

All right!!! Yes that was it, my source was "8:8" not 8:8.

It works just fine now, Thanks!!

[ragulduy]

No problem, for reference if you wanted to use "8:8":

Please Login or Register  to view this content.