Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Runtime Error "1004" Select Method of Range Class Failed
Hi -
Currently I have formatting macros attached to various Comboboxes and Toggle Buttons. I copied one of the macros below. The problem I am having now is when I try to insert cells on a different tab, I get the Runtime Error 1004. When I click on debug, it highlights the selected range of the macro (line 2 below). I can only make changes if I disable the macros. Can this be fixed? Application.ScreenUpdating = False Worksheets("Roll-up by RSM").Range("D13:G17,I13:L17,D21:G25").Select With Selection If Worksheets("Master List").Range("CA26") = "% of Sales" Then Selection.NumberFormat = "0.00%" Else Selection.NumberFormat = _ "_($* #,##0.00_);_($* (#,##0.00);_($*-??_);_(@_)" End If If Worksheets("Master List").Range("CA26") = "Total $" Then Selection.NumberFormat = "_($* #,##0_);_($* (#,##0);_($* ""-""_);_(@_)" End If End With Thanks in advance for your help. Stephen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Select method of Range class failed" Error | Excel Discussion (Misc queries) | |||
Runtime 1004 error -- insert method of range class failed. | Excel Discussion (Misc queries) | |||
Run-time error "1004" Select method of range class failed | Excel Discussion (Misc queries) | |||
runtime error '1004' delete Method of Range Class Failed | Excel Programming | |||
excel97: runtime error 1004 select method of range class failed | Excel Programming |