PDA

View Full Version : Identify cell formula changes in VBA



rogered
11-21-2014, 06:36 AM
Hi,

I have a range of cells containing different formulas. I have a macro which then hides some of these corresponding rows based on some IF statements. I would like to see which cells are grouped together based on the cell's formulas which refer to another sheet. e.g.

A3='SHeet2'!F47
A4='SHeet2'!F49
A5='SHeet2'!F50
A6='SHeet2'!F84
A7='SHeet2'!F85

So if the F cell is different from the previous one by more than 2 then it indicates a new group. I need to highlight when the cells change formula i.e. cells A3-A5 would be one colour and then A6-A7 a different colour.

I know how to do everything except identify the cell change in the formula.

Thanks for any help,

Rog