Easy one (I think)

[rob1987]

Hi,

I think this should be fairly easy but I can't work it out.

I have a named range that is hidden on one sheet. I want one of my Macros on a second sheet to unhide this range once the Macro is run. I can get various versions of a Macro to work fine if I enter the row numbers but not when I try and enter the range name - Range ("MB") -.

Can anyone help please?

 

[VoG]

Hi. try

Range("MB").EntireRow.Hidden = False

 

[rob1987]

Thanks, I just copied it straight in and it worked. I swear I tried that exact code though. I must have made a typo or something.

Thanks a lot for your help.