ExcelBanter - Get rid of formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Get rid of formulas (https://www.excelbanter.com/excel-programming/369430-get-rid-formulas.html)

bm4466[_11_]

Get rid of formulas

Anybody know how to make your sheet get rid of formulas once they
calculate. Say I want to Export the sheet - but I want just the
numbers to export, not the formulas, does anybody know hot to do it?

--
bm4466
------------------------------------------------------------------------
bm4466's Profile: http://www.excelforum.com/member.php...o&userid=33949
View this thread: http://www.excelforum.com/showthread...hreadid=568434

Mark

Get rid of formulas

try Copy...Paste Special and check the Values checkbox.

All times are GMT +1. The time now is 06:30 AM.