Excel macro convert to VBA - doesn't work, hangs on Range("Q35").Select
 

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

Excel macro convert to VBA - doesn't work, hangs onRange("Q35").Select
 

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

Excel macro convert to VBA - doesn't work, hangs on Range("Q35").Select
 

Thanks Dave, I don't know VBA yet, but your suggestion worked!

Thanks for your help.

Harold
====================
"Dave Peterson" wrote in message
...
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

Excel macro convert to VBA - doesn't work, hangs on Range("Q35").Select
 

Hi there, I just finished up solving a similar problem with my own
coding. I wish I could tell you what fixed it, but not really being a
programmer I don't really know. However, the person that fixed it was
Ron de Bruin, and he did a great job. Seek out his help.

Sincerely,
Amber:)


--
Amber_D_Laws
------------------------------------------------------------------------
Amber_D_Laws's Profile: http://www.excelforum.com/member.php...o&userid=30012
View this thread: http://www.excelforum.com/showthread...hreadid=501201