View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David Turner David Turner is offline
external usenet poster
 
Posts: 50
Default vba code needed for date

I have a sheet in which A3 will always be the 1st of the month, formatted
as 'd'. I want the code (NOT a formula or function) to look at that date
and change it to the 1st of next month, so I can then autofill days down
the column also with code (I know the code for that). I thought this would
be so easy since I've worked with much more complicated date routines, but
just can't come up with the code.

Range("A3")= ????

Any help?

--
David