Forum Discussion
Conditional Formatting Ranges Increasing on Data Refresh
Hi all, I have a spreadsheet that I've created to clean and sort data to create a planner of sorts for my team. I have a lot of conditional formatting rules in the output sheet to keep things cle...
Would you like to check the paste action, perhaps the system interprets it as an insert column action? I am no VBA expert but the only explanation for this 'anomaly' is that the paste as values action inserts a column first, which would inevitably expand the conditional formatting range.
Can you share the code in part or whole?
Can you share the code in part or whole?
I'll check, and should be able to share the code as it's not even a little proprietary, but there shouldn't be any reason for it to be inserting columns. The range it's being copied to is cleared before pasting, and while the code subsequently calls macros that do involve deleting/inserting rows, I don't feel that this is the issue, as there's no discernible mathematical relationship between the range sizes at each step. I'll try to share some later.