Worksheet Array Clearcontents

[Donai]

Hi,

How do i use clear contents worksheets array?

Worksheets(Array("Sheet1", "Sheet2")).Range("A6:V" & Rows.Count).ClearContents

 

[VoG]

Hi. Try

Dim ws As Worksheet
For Each ws In Worksheets(Array("Sheet1", "Sheet2"))
    ws.Range("A6:V" & Rows.Count).ClearContents
Next ws

 

[Donai]

Hi. Try

Dim ws As Worksheet
For Each ws In Worksheets(Array("Sheet1", "Sheet2"))
    ws.Range("A6:V" & Rows.Count).ClearContents
Next ws

Thanks Vog