Is there a formula that can "copy" data in one cell and then make it "static"?

Logit · #1 01-13-2024, 05:58 PM

This requires either the use of keyboard shortcuts ... or using the mouse and clicking menu selections. You can also create a macro that, once the affected cells are selected, will convert all those cells at once.

Not tested here :

Code:

Sub ConvertToValues()

Dim MyRange As Range
Dim MyCell As Range

Select Case

MsgBox("You Can't Undo This Action. " & _
"Save Workbook First?", _
vbYesNoCancel, "Alert")
Case Is = vbYes
ThisWorkbook.Save
Case Is = vbCancel
Exit Sub

End Select

Set MyRange = Selection

For Each MyCell In MyRange
If MyCell.HasFormula Then
MyCell.Formula = MyCell.Value
End If
Next MyCell

End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mailto Hyperlink Formula contains too large of "Body" receiving "#Value" need to find workaround	MCamera	Excel	1	03-02-2022 07:52 PM
Excel 2003: VBA "Function" causes "#VALUE!" errors after running "insert/delete row" custom macro	Matt C	Excel Programming	2	01-08-2022 06:03 AM
Conditional function to operate a formula based on "Yes" or "No" Condition	Des ONeill	Excel	1	07-03-2021 12:17 AM
Condtional function to operate a formula based on "Yes" or "No"	Des ONeill	Excel	3	07-03-2021 12:16 AM
'Linking' entered information to other "cells" from an original "cell" in MS Word	Wade	Word	6	09-03-2012 05:22 PM