I know there must be a solution to tihs, but I don't know
how. I need to go through each sheet in a workbook (could
be any number of sheets) and change the formula's to
values. I can do the formula to values bit but can' get
it to loop through all the sheets to the end.

TIA

Michael