Posted to microsoft.public.excel.programming

Patrick Simonds Patrick Simonds is offline

external usenet poster

Posts: 258

Sheet selection

Is there a way to amend this code so that it does not actually make the
sheet (in this case September) active?

Sub September_Set()

Sheets("September").Select

Range("D4:F13").Select
Selection.Value = ""
Selection.Offset(0, 26).Value = ""

Range("D15:F25").Select
Selection.Value = ""
Selection.Offset(0, 26).Value = ""

Range("A2").Select

End Sub

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
Sheet selection help	Craig McK	Excel Programming	6	October 30th 06 02:33 PM
Calculate active sheet on sheet selection	a94andwi[_11_]	Excel Programming	1	September 26th 05 05:23 PM
Selection from list on main sheet from suplemental sheet in same w	Kelly	New Users to Excel	1	August 12th 05 04:37 PM
search in a sheet and selection?	EM	Excel Discussion (Misc queries)	0	February 2nd 05 02:43 PM
Sheet selection	No Name	Excel Programming	1	October 6th 04 05:02 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us