Tab names versus sheet1 name?

[thecdnmole]

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!

[oeldere]

You could refer in VBA to the sheetnumber.

[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:

Please Login or Register  to view this content.

Ciao,
Holger

[thecdnmole]

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!

[thecdnmole]

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??

[thecdnmole]

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:

Please Login or Register  to view this content.

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!

[thecdnmole]

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?

[HaHoBe]

Hi, thecdnmole,

the last question canīt be answered by anybody but you who sees both the code and the contents of the workbook, and I really doubt that

Please Login or Register  to view this content.

is correct as I think it should be

Please Login or Register  to view this content.

referring to the fifth sheet in the workbook (for me from the left side of the sheets no matter what kind of sheet the fifth is: worksheet, chart).

Ciao,
Holger