Hi all,
I am attempting to copy and insert a range of columns within a sheet of mine. Within this range of columns are two Conditional Formats that get copied along aswell, though they do no fill the entire range of the columns.
Along with duplicating the range and the formatting I wish to edit the formula of the Conditational Formats to reference new absolute cells.
Hence: Is there a way to edit the formula of an exsisting Conditional Format within VBA?
I have tried the following, with Error: 438 Object doesn't support this property or method.
Looked about and cannot find a way of doing this without generating a new Conditional Format with .add. Ideally I just want to edit them, rather than delete and generate new ones. Any suggestions?
Oliver
Bookmarks