Spreadsheet Review Macro

N

Nick Ward

Dear All

I am after a macro that anyone may have devised which
looks line by line and judges whether the row has a unique
formula at the begining which is the same all the way
across, then skips down to the next row and colour codes
if it finds any unique formulas, then will skip sheets and
go to the next sheet and repeat until the end.

If anyone can help out it would be greatly appreciated.

Cheers
Nick
 
N

Nick Ward

Hi Frank

In a financial model I want to ensure that the formula in
the first cell is copied across properly and is not hard
coded or that the formula changes progressively through
the row. For consistency and transparency the formulas
should all be the same
 
F

Frank Kabel

Hi
you may post your current formula. But from your
description it sounds like you need absolute references.

but as said: post your desired formula
 
Top