Range method error
 

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?

Range method error
 

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 ?

"EXCELKO" wrote:

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?

Range method error
 

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
--
TDay


"EXCELKO" wrote:

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?