Posted to microsoft.public.excel.misc

jlclyde

external usenet poster

Posts: 410

VBA question about selecting worksheets

On Apr 17, 10:17*am, Gary''s Student
wrote:
Sub Tryingsomething()
Sheets(Sheets("Sheet1").Range("A1").Value).Activat e
Range("A1").Select
End Sub
--
Gary''s Student - gsnu200779

Thanks,
this is eactly what I was looking for. I always seem to forget to
activate the sheet before selecting something on it.
Thanks again,
Jay

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
selecting cells in different worksheets	Kaitlin.uk	Excel Discussion (Misc queries)	2	January 17th 07 04:46 PM
Comment BUG- selecting cells on other worksheets	CFD	Excel Discussion (Misc queries)	3	March 6th 06 07:04 AM
Selecting and viewing sum in status bar across worksheets	JMS	Excel Discussion (Misc queries)	2	July 15th 05 02:28 PM
Selecting and summing across worksheets	JMS	Excel Discussion (Misc queries)	2	July 15th 05 01:06 AM
Selecting across worksheets	JMS	Excel Discussion (Misc queries)	1	July 14th 05 10:44 PM

All times are GMT +1. The time now is 02:38 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us