Sheet Selection Query

Firstly, just wanted to say hello to everyone as i am a new member.

I am trying to get to grips with VBA, and figured the best way was to look at elements of my working day, and see which things can be automated. I have had some success which is spurring me on to trying more.

However, i am trying to get the code to select a particular sheet within a workbook. The problem is that the workbook we use gets updated, and as such, every update involves the creation of a new sheet.

The work i do is always on the forth to last sheet in the workbook, and so how would i make the code activate the 4th to last sheet?

Thanks in advance

Put those 4 sheetnames in an array:

Please Login or Register  to view this content.

The code will always select the same sheets (based on the sheetnames, not numbers)

If you want to select the 4 most recent sheets:.

Please Login or Register  to view this content.