Open Hidden sheets to specific point

[rhani111]

Hi All,

Lets hope my internet won't crash before this one posts...AGAIN...lol

I have hidden sheets that I have got a macro to open once the button is
selected, but I want the macro to open at a specific point.

Here is the END only of the macro

Sheet54.Visible = xlSheetVisible
Sheet2.Visible = xlSheetVisible
Range("C8").Select
End Sub

How do I do this, so that Sheet26 is the one that the macro opens at?

Thanks in advance
Sandi

 

[JMB]

At the end try using

Sheet26.Activate
Range("YourRange").Activate

 

[rhani111]

Thank you ...Thank you...oh Thank you...


Worked perfectly!!!!!
Sandi