VBA Solution Needed

Topic

New Reply

How would I write a macro to insert the results of the formula below into Cell G10. I need to return the number of days between today and the date entered in E10.
I also need it to be a “change event”. I think!

=IF(E10=””,””,NOW()-E10)

Reply | Quote

Replies

You can use code like this:

Code:

Sub MyMacro()
  Range("G10").Formula = "=IF(E10="""","""",TODAY()-E10)"
End Sub

Note that the quotes within the formula have been doubled. This is necessary whenever you need quotes within a quoted string in code.

Reply | Quote

Thanks

Reply | Quote