Why won't this work? - ExcelBanter

Posted to microsoft.public.excel.programming

Steph[_3_] Steph[_3_] is offline

external usenet poster

Posts: 312

Why won't this work?

Hello. I'm sure this a pretty dumb question, but any ideas why this
won't work??

Set clrarray = Sheets(Array("Forecast", "LMU", "Kit", "SMLC", "WLG",
"SMLC Cab", "Serv Cab", "Ntwk Kit", _
"TDAX", "EMS", "SCOUT", "Dir Coup"))

ActiveWorkbook.Worksheets(clrarray).Range("A5:EC50 0").ClearContents

Thanks!

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
Macro to update a column in a work based on another work sheet	WickerMan	New Users to Excel	1	December 4th 09 12:58 PM
how can i automatically generate work order numbers from work orde	rob h	Excel Discussion (Misc queries)	1	July 13th 09 07:59 PM
flash object dont work in my excel work sheet	Nitn	Excel Discussion (Misc queries)	0	July 4th 09 08:00 AM
Counting dates in multiple work sheets and work books	Savage	Excel Discussion (Misc queries)	0	December 19th 05 11:41 PM
Is there away to keep "auto save" from jumping to the first work sheet in the work book?	Marc	New Users to Excel	2	April 21st 05 01:27 AM

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

Menu

About Us