Dates in VBA
I'm trying to do something very simple in Visual Basic, but am having
trouble.
All I want to do is put a date in a certain cell, based on a date in a
different cell on a different sheet.
The formula I would use if it weren't visual basic is:
=DATE(Year(Info!G2),Month(Info!G2),1)
How can I do this using visual basic?
Thanks!
Brett
|