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 |
All times are GMT +1. The time now is 03:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com