Remove the Excel table formula and retain only the numeric value

To work, you need to remove the table formula and retain only the numeric values. It is usually difficult to use "selective pasting", so you have written the following VBA program (Excel macro file ), one-click removal of all the formulas in the table in the workbook and only the values are retained. The program code is as follows:

Sub call1 ()

Dim I as long

Dim X as long

X = worksheets. Count

For I = 3 to X

Sheets (I). Select

Cells. Select

Selection. Copy

Selection. pastespecial paste: = xlpastevalues, Operation: = xlnone, skipblks: = false, transpose: = false

Next

Msgbox "formula removed and only numerical values are retained"

End sub

This article is from the "travel life" blog and will not be reproduced!