I am trying to delete the same specified rows from a each sheet within a
collection of sheets in a workbook. Using code analogous to the following,
I'm getting a error.
If this is incorrect, is there a way to do it without actually "selecting"
the different sheets?

Sheets(Array("A", "B","C","D","E","F") ).Rows("5:10").Delete

Thanks

Hi AVR

Try this

Dim sh As Worksheet
For Each sh In Sheets(Array("A", "B", "C", "D", "E", "F"))
sh.Rows("5:10").Delete
Next sh


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"AVR" <(E-Mail Removed)> wrote in message news:8CD69E06-3F01-43FC-B9B9-(E-Mail Removed)...
>I am trying to delete the same specified rows from a each sheet within a
> collection of sheets in a workbook. Using code analogous to the following,
> I'm getting a error.
> If this is incorrect, is there a way to do it without actually "selecting"
> the different sheets?
>
> Sheets(Array("A", "B","C","D","E","F") ).Rows("5:10").Delete
>
> Thanks