Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL VBA - Find Method or Range in IE throwing error | Excel Programming | |||
Object range method runtime error | Excel Programming | |||
Range Question / error 1004: method Range of object Worksheet has failed | Excel Programming | |||
<Method 'Range' of object '_Global' failed error | Excel Programming | |||
HELP!!!! -- (Method Range of _Worksheet failed) ERROR! | Excel Programming |