PP3321
Active Member
Dear Chandoo Community,
I am sharing some of the strategies that I came up with
in order to prevent errors when working with Excel
I would be extremely grateful if you could share yours
1. Visibility of formula
I try to check every formula contained in the Excel before submitting using VBA below.
2. State of mind (reminding me to focus on accuracy)
I have this message popping up everytime I open Excel
I am sharing some of the strategies that I came up with
in order to prevent errors when working with Excel
I would be extremely grateful if you could share yours
1. Visibility of formula
I try to check every formula contained in the Excel before submitting using VBA below.
Code:
Sub DebugPrint_GetAllFormulas()
Dim c As Range
For Each c In ActiveSheet.UsedRange
If c.HasFormula Then
Debug.Print c.Formula
End If
Next c
End Sub
2. State of mind (reminding me to focus on accuracy)
I have this message popping up everytime I open Excel
Code:
Private Sub Workbook_Open()
MsgBox ("Fast is fine, but accuracy is everything.")
End Sub
Last edited: