Many thanks VBAjedi and Loomah.
That is a typo in the posted code (soz), it took me several squints to spot it when you pointed it out, I really am a lazy reader and don't possess true coder's eyes (thank 'eavens for the debugger).
I tried "Worksheets("sheet2" ).Activate"...
Background
I am new to VBA (as you will probably soon surmise), so maybe this is not exactly the right forum for me. I am working on a little project at work using Excel 2000 and its budled version of VBA (I work for a huge government organization that prides itself on its electronic office...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.