ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Navigating between worksheets. (https://www.excelbanter.com/excel-worksheet-functions/5641-navigating-between-worksheets.html)

shazza

Navigating between worksheets.
 
how can I create a macro that will allow me to navigate
between worksheets in the one workbook.

It has to be a macro because of the project I'm currently
working on.

student.

ForSale


I'm relatively new here, but i think this would be more qualified for
the Programming forum.
but the answer is either
Sheet1.Select
or
Sheets("SheetNameHere").Select

The first example goes by the unchangeable excel-given name of the
sheet, the second by the name that you give it.


--
ForSale
------------------------------------------------------------------------
ForSale's Profile: http://www.excelforum.com/member.php...o&userid=11896
View this thread: http://www.excelforum.com/showthread...hreadid=275115



All times are GMT +1. The time now is 04:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com