Sheet reference in macro

[gshock]

Can you refer to a sheet by # (as it displays in the project window) instead of using

Please Login or Register  to view this content.

?

For example, could I simply say,

Please Login or Register  to view this content.

instead?

Thanks.

-gshock

[royUK]

If you look in the VB Editor properties window you will see the sheets listed like this

Sheet1(Sheet1)

Sheet1 in brackets will change if the sheet tab is renamed, this is the WorkSheet Name.

Sheet1 outside the brackests cannot be altered except within the VB Editor. This is the sheet's Codename. IOt is usually better to use this in your code in cae anyone changes the tab's name in the workbook.

[gshock]

If you look in the VB Editor properties window you will see the sheets listed like this

Sheet1(Sheet1)

Sheet1 in brackets will change if the sheet tab is renamed, this is the WorkSheet Name.

Yes, this is exactly what I was referring to.

IOt is usually better to use this in your code ....

Not sure what you mean. What is "IOt?" I think I've got the same idea. I want to avoid any circumstances where someone might change the tab name later.


So are you saying that if I have something like this:

Please Login or Register  to view this content.

my code could read like this instead:

Please Login or Register  to view this content.

???

Thanks,
-gshock

[royUK]

Sorry about the typo, this code should work fine.

Please Login or Register  to view this content.

[gshock]

Sorry about the typo, this code should work fine.

Please Login or Register  to view this content.

royUK,

That's great. Thanks for the tip. I wasn't being picky. I just didn't know if I missed something or not. I thought it might be an abbreviation I wasn't familiar with. Thank you.

Regards,

-gshock

[royUK]

No problkem, this laptop has a small keyboard so I often catch two keys!