convert formulas into values

[shamsu203]

HI
I have a vba which converts formulas into values . I want to know if it is possible for the macro to run on completion of a certain period say 12 month based on the date difference between todays date and the start date. the macro i use is given beow
Sub ConvertToValues()

Dim MyRange As Range

Dim MyCell As Range

Set MyRange = Selection

For Each MyCell In MyRange

If MyCell.HasFormula Then

MyCell.Formula = MyCell.Value

End If

Next MyCell

End Sub
tks for any suggestion you provide
shamsu

 

[shamsu203]

Hi
THe new code works perfectly?. Tks for ur patience and help. one last question to automate it so that the macro is run every time the workbook is opened should I add the the two line code to the worksheet named expense

 

[Yongle]

As mentioned previously, this code should be placed in ThisWorkbook code window

Private Sub Workbook_Open()
    Call ConfirmValues
End Sub

 

[shamsu203]

Tks once again for ur help much appreciated ?