Tab names versus sheet1 name?

When referring to worksheets in VBA, do you have to use the name on the sheet tab or can it simply be called Sheet1, Sheet2 etc? I have macro's that change the name of the tab, therefor I have been writing macro's for each of those scenarios (14), whereas if you can refer to the tab as a generic, such as sheet1, this would help a lot! What line would you use then to check if say sheet4 is visible, if so, continue, if not, skip to next sheet? Thanks!

Originally Posted by HaHoBe

Hi, thecdnmole,

you may refer to the code name of the sheets and use these as they could only be altered by VBA or in the VBE.

Without further or deeper information on what you want to do:

If Sheet4.Visible Then
  'do your stuff
Else
  Sheet5.Select
End If

Ciao,
Holger

I started to have errors if the sheets were not visible, so the line between Else and End I just added the "'" and things worked. Now I found a post which says that line should be written like this...

Sheet(5).Select

This appears to be working now. Darn picky VBA for a newbie!

Thanks oeldere and HaHoBe. Music to my ears, but wish I knew that a month ago! Need to take a course on VBA! Thanks for the code to skip over sheets not visible, which now means using one macro for all scenarios!

Does the whole macro need to be done one way or the other or can you mix sheet15 with "Welcome"(tab name)? I just tried it in a macro and go an error on the line I changed. Is it entered as Sheet15, or do I need something else, like an exclamation mark??

Well that does not work either! If I use code names, when I run a different macro it appears that when I ask it to take the image from Sheet26 it takes it from another sheet! But if I put the tab name, Sheet("Welcome") it works. I thought if you use the sheet code name the macro should work no matter? Any ideas?