Hi,

I'm looking to loop through each ws in the current workbook and, for
each w/sheet, programatically get the highest value in one of the
columns, count the number of occurrences of a cartain variable in
another column and return these values programatically so I can create
a Front Page type of thing.

I think I understand how to get the list of worksheets i'ts after that
I get stuck...I've no idea how to reference cells in a worksheet from
within vba.

also....

is it possible to run the code I create ONLY when a certain cell value
is changed on the Front PAge???

TIA