In the new workbook, do you want the formulas replaced by blanks or by the
values from the old workbook?
--
Gary''s Student - gsnu200811


"FARAZ QURESHI" wrote:

I have a workbook consisting around 20 sheets. I want to copy all the same to
a new workbook with only values. Any shortcut how to remove all the formulas
instead of copypaste specialvaluesok on every sheet?
--
Best Regards,
FARAZ A. QURESHI