How to do something in an VBS script for all worksheets of an Exce
Hi
Sub sonic()
for x=1 to worksheets.count
worksheets(x).select
'do your stuff
next
end sub
depemding on what you are doing you may not (probably won't) need to select
Mike
"Claudia d'Amato" wrote:
I would like to do something in a *.vbs script and all the operations should be applied
on each worksheet within an Excel file.
How do I do this?
It must be something like:
for i in (1 .. lastworksheetnumber) do
...operations
end
Claudia
|