ThisWorkbook Question

[Pinaceous]

Hi All,

I'm trying to use a different code structure for the NAMED tab of "Tab_ONE" with the following:

ThisWorkbook.Sheets("Tab_ONE").Range("B11:X180"))

Is there anyway to restructure this to use the for example, Worksheet(2) in lieu of "Tab_ONE"??

Please let me know, if you should have any questions.

Thank you,
Pinaceous

 

[DanteAmor]

If the sheet occupies position 2 of your sheets then simply:

ThisWorkbook.Sheets(2).Range("B11:X180")