How to refer to the (NAME) of the Sheet rather than the Name of the sheet in my macro

Dear Sirs,
I am running this easy macro, see below. My problem is that it only works if the sheet (tabs) are called 1, 2, 3, 4,...etc. The users of the spreadsheet often change the TAB sheets so I would like the macro to refer to the actual (NAME) of the sheet, the one that you find first under the PROPERTIES section of the Microsoft Visual Basic Editor. Could anyone help?

Kind regards
Creare

Please Login or Register  to view this content.

Welcome to the forum

Pls take a few minutes to read forum rules, because:

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between

Please Login or Register  to view this content.

tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

This time i'll do for you. I am waiting to do it yourself next time.

Thank you.

assuming the tags will appear ;-)

Please Login or Register  to view this content.

where Sheet1 is the codename

My apologies Fotis1991.
Thank you for your comment.

Thanks for undrstanding! Does the suggestion by JosephP worked for you?

you're welcome :-)

please don't forget to mark the thread solved (click the 'thread tools' link at the top, then 'mark solved')

Thanks for the feed back.

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thank you.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.