VB question

[tim963]

Hi I need a line of code to put January 1 of the current year in G3, so if the Marco was run today it would put 1-1-2002 in G3, if it was run next year it would put 1-1-2003 in G3. Can this be done? Thanks, using excel ‘97

 

[stevebausch]

I would suggest posting your failed attempts at creating the code. We can then offer guidance as to achieving your goal.

 

[dsnbld]

I think this will work.
Range("G3").Value = "1/1" & YYYY
Custom format cell with this, m-d-yyyy

_________________
Win 98SE - Office 2K
This message was edited by dsnbld on 2002-08-28 18:00

 

[tim963]

dsnbld, thanks that will work!

 

[dsnbld]

Glad to hear it helped