How to do something in an VBS script for all worksheets of an Exce
hi
something like this might work...
Sub claudia()
For i = 1 To Worksheets.Count
Worksheets(i).Range("A1").Interior.ColorIndex = 6
'above is for test only
Next i
End Sub
regards
FSt1
"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
|