Using a macro to move to next sheet

[mattsgr1]

Is there a way to move from one sheet to the next by using a macro or any other method??

I know you can simply write:

sheets("Sheet1").select

This is all well and good until I delete this page or insert one in front of it. If the tab is deleted the macro will crash. If a sheet is inserted in front of it, this macro will skip the new sheet.

I just want to move to the next sheet in the workbook... I've been stumped by this for ages now.

Any help is appreciated.

Thanks

[Carim]

Hi,

Please Login or Register  to view this content.

[mattsgr1]

Hi,

Please Login or Register  to view this content.

Thank you very much. That worked great!!

However, if it is the last page it crashes. Do you know a way to stop the code from working if it is the last sheet in the workbook??

[Carim]

Glad it fixed your problem ...

Please Login or Register  to view this content.

Thanks for the feedback

[mattsgr1]

Thanks for all the help, however. . .

I have a new requirement. If I am on the last sheet instead of selecting the same sheet again, is there a way that I can get back to the 1st sheet in the workbook?

[Carim]

Hi,

Please Login or Register  to view this content.

[mattsgr1]

Thanks again.

How did you get so knowledgeable???

[Carim]

Glad it fixed your problem ...

Thanks for the feedback


P.S. Knowledge is always relative ... and directly function of ...practice ...