You can only select a range if it's on the selected worksheet.

With worksheets("Othersheetnamehere")
.select
.range("Q35").select
end with

But most of the time, you can work directly against the range and avoid the
selecting.

With worksheets("Othersheetnamehere")
.range("Q35").clearcontents 'say
end with

Harold Good wrote:

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

--

Dave Peterson