Hi,
I created a macro, then later decided to activate it via a ActiveX Option
Button. As a macro it works fine.
I copied the macro text into the View Code property of the Option button,
and when I step through it in VBA it gives a Run time error 1004 when it
comes to Range("Q35").Select. Interesting because about 10 steps earlier it
handles Range("N23:N34").Select just fine - if I'm on the correct worksheet
to begin with. But the Range("Q35") error occurs no matter if I am on the
correct worksheet.
Any help would be appreciated.
Thanks,
Harold
Bookmarks