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

Range(sheet2) = Range(sheet1) 11
named range 2
Combobox selection 1
How to Load Combo Box with Named Range 4
Combobox Rowsource 2
Error Message - Macro to Unlink MS Queries from Workbook 0
Error Message 3
Data Validation AutoComplete Help 5

Top