Clear Array

[billandrew]

Evening all

something simple - maybe someone can explain why the the below errors out

Sheets(Array("Sheet2", "Sheet3", "Sheet4")).Range("A1").CurrentRegion.Clear

 

[billandrew]

I have a script which does what I need - however trying to utilize array method.

Sub DeleteCurrentRegion()

Dim s As Worksheet
For Each s In Worksheets
If s.Name <> "Sheet1" Then
s.Range("A1").CurrentRegion.Clear
End If
Next
End Sub

Thank you for any explanation.

 

[Rick Rothstein]

Evening all

something simple - maybe someone can explain why the the below errors out

Sheets(Array("Sheet2", "Sheet3", "Sheet4")).Range("A1").CurrentRegion.Clear

When you use an array argument of sheet names like that, the assumption is you are doing the same thing to all sheets. My guess... Excel probably assumes the CurrentRegion will (or at least could be) different on each sheet, so it cannot be sure it would be able to do the same thing on each sheet.

 

[billandrew]

Thank You Mr.Rothstein


In this example I am attempting to clear the range which may be different?

Worksheets(Array("Sheet2", "Sheet3", "Sheet4")).Range("A1" , Range("Z" & Rows.Count).End(xlUp)).Clear