and change the formula's to values.

Another technique is to loop on only Worksheets, and avoid the chance of
selecting a Chart Sheet, or an Excel 4 macro sheet.

Dim Sht As Worksheet
For Each Sht In ActiveWorkbook.Worksheets
Sht.Activate
'Your code ...
Next

HTH
Dana DeLouis

"michael" wrote in message
...
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