selecting the last 5 sheets

[aishaz_88]

Hi

I need help again. I would like to know how do i select the last 5 sheets.

for example I have sheet:

1 2 3 4 5 6 7 8

and i would like to only run a macro on the last 5 sheets.This macro is being run on a weekly basis. keeping in mind that the naming of the sheets may vary everytime i run the macro..so any help please?

[jindon]

try

Please Login or Register  to view this content.

[aishaz_88]

Thanks your solution works great.

Helped me a lot.
I was busy with some other projects that i had really no time to come back to this project till now.

Thank YOU!~