Posted to microsoft.public.excel.programming

Quietman

external usenet poster

Posts: 109

Selecting a worksheet based on the sheet Number

Can anyone tell me why the code does not work

TTK = 40
Sht_Select = "Sheet" & TTK
Sheets(Sht_Select).Select

Thanks

--
Helping Is always a good thing

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Rename Worksheet without Selecting the sheet	Don Guillett	Excel Programming	0	December 12th 06 06:48 PM
Rename Worksheet without Selecting the sheet	[email protected]	Excel Programming	0	December 12th 06 06:38 PM
Selecting sheets based on cell in each sheet	Steve	Excel Programming	2	August 4th 06 07:48 PM
Selecting a number of rows based on the content	matpj[_25_]	Excel Programming	3	November 25th 05 09:27 AM
Selecting a sheet based on a cell	wilcster	Excel Programming	3	December 30th 04 05:05 PM

All times are GMT +1. The time now is 03:52 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us