for each sh in Worksheets
sh.UsedRange.Cells.Value = sh.UsedRange.Cells.Value
Next

Merged cells may be problematic (aren't they always) - I haven't tested it
with those.
--
Regards,
Tom Ogilvy


"dogpigfish" wrote in message
...
I am bouncing around code for this and overcomplicating it. What code can
I
use to paste all values on every sheet for every cell.