Range method error

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?
 
D

Dan Thompson

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 ?
 
T

TDay

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

Select method failed - Error 400 2
Iterating through a ComboBox's values 6
VBA for Dependents shortcut menu 0
use ComboBox value to select range and then use selected range tocreate a chart 3
Hyperlink in Commandbutton 4
Combo box 0
Data Validation AutoComplete Help 5
XL2003 Userform; cmbbox uses named range source, changes unexpecte 1

Top