ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Switching between Worksheets (https://www.excelbanter.com/excel-programming/309294-re-switching-between-worksheets.html)

Dave Peterson[_3_]

Switching between Worksheets
 
In the activeworkbook?

worksheets("Data Input").select

worksheets(cstr(height)).select

Not sure if "2000" meant it was actually text or numeric.



Ben H wrote:

Hi all! I need to switch between different worksheets. The worksheets I am
switching between are called "Data Input" and someother variable, called
Height, which currently has "2000" in it. Is there a good way to do it?

Thanks!


--

Dave Peterson



All times are GMT +1. The time now is 05:22 PM.

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