nikki333
12-05-2018, 01:59 PM
Hi Folks
I'm trying to loop trough worksheets e.g. in order to do some formatting for each of them
The problem is that i get an error 424 (Object required) each time.
The relevant lines of code look like so:
dim i as long
dim arrBlätter as variant
arrBlätter = Array("wsAllg", "wsGF", "wsFo1", "wsFo2", "wsFo3", "wsFo4")
For i = 1 To UBound(arrBlätter)
Set ws = arrBlätter(i)
With ws
...
End With
Next i
So the error comes in at this point: "Set ws = arrBlätter(i)"
Any idea what i'm missing here
Many thanks and cheerrs
I'm trying to loop trough worksheets e.g. in order to do some formatting for each of them
The problem is that i get an error 424 (Object required) each time.
The relevant lines of code look like so:
dim i as long
dim arrBlätter as variant
arrBlätter = Array("wsAllg", "wsGF", "wsFo1", "wsFo2", "wsFo3", "wsFo4")
For i = 1 To UBound(arrBlätter)
Set ws = arrBlätter(i)
With ws
...
End With
Next i
So the error comes in at this point: "Set ws = arrBlätter(i)"
Any idea what i'm missing here
Many thanks and cheerrs