Using VBA to pull only the necessary data from a sheet, and deleting the rest, but the sheet has formulas and conditional formatting.
Logic I have written so far is, if a row needs to be deleted, before deleting a row I use Range.DirectDependents to find any cells that use the cell to be deleted in their formula and replace the cell address in the dependants formula with whatever value or formula is in the cell to be deleted. So this logic works for the formulas, but now the Conditional formatting... Is there any method like DirectDependents that I can use for conditional formatting to get this same logic?
Logic I have written so far is, if a row needs to be deleted, before deleting a row I use Range.DirectDependents to find any cells that use the cell to be deleted in their formula and replace the cell address in the dependants formula with whatever value or formula is in the cell to be deleted. So this logic works for the formulas, but now the Conditional formatting... Is there any method like DirectDependents that I can use for conditional formatting to get this same logic?
