Hi There,
I've done this before but I have no idea how?? Must be getting old!
anyways,
Lets say I have 10 worksheets and 5 of them are named
test1,test2,test3......
the other five have different names.
I would like to cycle through the five sheets with a "for next loop", hoping
I could join "test" & x.

for x = 1 to 5
vtest="test" & str(x)
vtest.range("A1").value= "Oh My God.. It worked"
next x
I seem to get messed up with the declaring part... I keep getting an error
everyway I try.
Thanks as usual for your help
Craig