Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I'm new to VBA programming and am attempting to add a 4th conditional format by editing a recorded macro and am receiving this error message. Here is my code: Sub Conditional_Formatting() ' ' Conditional_Formatting Macro ' Macro recorded 4/26/2007 by Jhammel ' ' Keyboard Shortcut: Ctrl+j ' Selection.FormatConditions.Delete Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _ Formula1:="=""""""Materials""""""" Selection.FormatConditions(1).Interior.ColorIndex = 36 Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _ Formula1:="=""""""Turnkey""""""" Selection.FormatConditions(2).Interior.ColorIndex = 34 Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _ Formula1:="=""""""Labor""""""" Selection.FormatConditions(3).Interior.ColorIndex = 33 Range("E2").Select Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _ <---------LINE GENERATING ERROR Formula1:="=""""""None""""""" Selection.FormatConditions(4).Interior.ColorIndex = 35 Range("E2").Select End Sub Any help would be appreciated. Thanks Jan Hammel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Run-time error '50290': Application-defined or object-defined erro | Excel Discussion (Misc queries) | |||
Application-Defined or object defined error 1004 When ran on exel97 but not 2003 | Excel Programming | |||
Runtime error 1004- application defined or object defined erro | Excel Programming | |||
Runtime error 1004- application defined or object defined erro | Excel Programming | |||
Runtime error 1004- application defined or object defined erro | Excel Programming |