Keyboard shortcut for switching through worksheets

Hello!

I need keyboard shortcut for switching through worksheets.

For now, I have this VBA macro and shortcut Ctrl+R:

Please Login or Register  to view this content.

But, there is a problem: when i am on the last sheet, and want to go to the first, there is Error.

Any suggestions?

Thanks in advance.

Sinke

You can actually use Ctrl+Page Down or Ctrl+PageUp for that (it has the same limitation), or just use the sheet navigation buttons in the bottom left corner?

sinke, Welcome to the Board,

Your post does not comply with Rule 3 of our Forum RULES.
Use code tags around code.
Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window.

For more information about these and other tags, found here

sinke, my post was not a "suggestion".

You obviously have a different keyboard than mine...

You would need a check to see if activesheet.Index is equal to either 1 or Sheets.Count (depending on which way you are going) and then select the relevant sheet rather than the previous/next.

if you must then you could just use on error

Please Login or Register  to view this content.