REPOST: Need help with XL2007 FormatConditions, please?

Tech-Archive recommends: Fix windows errors by optimizing your registry

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 = Active***
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
.

Quantcast