Sheet Codename

Hi all,

I need a bit help in modifying this single line code given below.

HTML Code: 

The Sheet name "CONTROL SHEET" can be changed any time, so I want to use the Sheet codename (like Sheet1, Sheet2 which are permanent) but unable to do so.

Help plz.

Each sheet has a specific codename that doesn't change. Identify the sheet code name and you should be able to do something like this: Note: You can see the code name in the VBE

Please Login or Register  to view this content.

@stnkynts

Thanks a lot..!!