Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to understand FormatConditions in XL 2007??
In an XL2007 .xlsm workbook, I have a Worksheet_Change macro that
captures the row I'm entering data into and copies down all the formats and formulas from the row above. This is done by selecting certain ranges and cells, using Copy, and then PasteSpecial. Apparently this is screwing up my conditional formats. Thanks to Jim Rech, I dug a bit deeper into FormatConditions. Now I am totally confused! I have a dozen columns with conditional formats. Yet when I did Set wks = ActiveSheet MsgBox wks.Range("A21:Z1000").FormatConditions.Count I get 1188 FormatCondition objects!!?? Really, all I want to do is iterate through each column and ModifyAppliesToRange to extend the format one cell farther down. Am I going to have to ClearFormats and Add the format back in with the new range every time? Anyone who can help me make sense of this is most appreciated!! Ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems using FormatConditions.Add with an Expression | Excel Programming | |||
excel2k FormatConditions question | Excel Programming | |||
What is the parameter for FormatConditions? | Excel Programming | |||
FormatConditions VBA Bug? | Excel Programming | |||
FormatConditions(1).Formula1 | Excel Programming |