+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Harold Good
    Guest

    [SOLVED] 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




  2. #2
    Forum Contributor
    Join Date
    12-30-2005
    Location
    Mobile, AL
    Posts
    102

    Seek out Ron's help

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1