VBA to select a sheet by its none changable name part?

[tonywatsonhelp]

Hi Everyone

I have a sheet and in the VBA it shows as Sheet3 (Home)
how do I select this by the name Sheet3 not Home
its not the 3rd sheet and could be moved or renamed so this seams the best way.

Thanks

Tony

 

[Peter_SSs]

Sheet3.Select

 

[silentwolf]

Hi,

just by Sheet3

with Sheet3.range("A1")
'do what ever you like to do
end with

 

[tonywatsonhelp]

Thank you,
I must have tried everything but LOL

Tony