|
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
|
|
#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
|
|
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 10 
Office 2007
Hybrid Mode