Range method error

  • Thread starter Thread starter EXCELKO
  • Start date Start date
E

EXCELKO

Hi All,

I using commandbuttons to move between sheets and
I can move back and forth until I have used a combo button in one of the
sheets. After I have used it I can still return to the "Menu" page BUT when I
try to return to the sheet containing the ComboBox I get range method error
(RTE1004). The error reports from the code within the ComboBox - Is this
something to do with putting the code in the combobox or just my rubbish
grasp of code?
 
It would help if you provide more information with your question like maybe
your code or the part that the error is getting stuck on ?
 
Are you using the following line of code to move from sheet to sheet:
Worksheets("Slides").Select

or are you moving to a named range:
Application.Goto Reference:=Worksheets("Slides").Range("Welcome"),
Scroll:=True
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlink in Commandbutton 4
Embedded Combobox (Form Control) 4
Iterating through a ComboBox's values 6
use ComboBox value to select range and then use selected range tocreate a chart 3
Autofilter by combobox selection 1
preventing comboboxes from triggering when sheet copied 1
XL2003 Userform; cmbbox uses named range source, changes unexpecte 1
Data Validation AutoComplete Help 5

Back
Top