Nope.

You could loop through the indices, though. That's what the second suggestion
did.



al wrote:
Dave Peterson

Dave thxs the macro works thxs - 1 last question to you - can you
instead of
for each ws in worksheets(array("france","germany","Italy","Spain "))
using something else starting from "france" to "spain" i.e gemany &
italy in between included
e.g for each ws in worksheets(array("france" to "Spain"))
pls advise

--

Dave Peterson