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!
|