Posted to microsoft.public.excel.programming

Patrick C. Simonds Patrick C. Simonds is offline

external usenet poster

Posts: 343

Selecting a worksheet

I need code to select a specific worksheet. I can not use the name on the
tab since I have code which renames the worksheet based on data input.
Currently if you look at the VBA Project the name is Sheet1(01 Jan 09). It
is the 01 Jan 09 which can change, but the Sheet1 stays consistent. So how
can I select the worksheet based on the Sheet1

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
Sorting a range on another worksheet without selecting the worksheet	[email protected]	Excel Programming	1	December 21st 06 11:06 PM
Selecting Next Worksheet	Fleone	Excel Programming	3	May 2nd 06 05:05 PM
selecting a worksheet	rocket0612	Excel Worksheet Functions	2	March 1st 06 09:47 AM
selecting cell range in other worksheet without switching to worksheet	suzetter[_4_]	Excel Programming	4	June 22nd 05 08:55 PM
Selecting Last Worksheet	Alex	Excel Programming	7	September 26th 04 09:35 PM

All times are GMT +1. The time now is 01:16 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us