Say I am using the following in the first macro. Once the macro is completed, I use a 2nd macro to clear the fields on the spreadsheet to reuse it using the first macro. Is there a way to clear out the variables globally so that macro can run cleanly? Without using each of the variable names (as they vary from sheet to sheet) since the 2nd macro clears out many other spreadsheets?
Dim dataSheet As String, iDRG As Variant, iDescrip As Variant
Dim allowance As Variant, dataFound As Range
Dim dataRange As Range, billedCharges As String, adjustedCharges As String
Dim rev278 As String, notOulier As Boolean, outlierPercent As String
Dim outlierCharge As Double, outlierPayment As Double
Dim payment As Double, originalDue As Double
Bookmarks