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

Logit · #4 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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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