Thread
:
Dates in VBA
View Single Post
#
4
Posted to microsoft.public.excel.misc
[email protected]
external usenet poster
Posts: 48
Dates in VBA
That did it! Thanks a lot!
Dave Peterson wrote:
dim myCell as range
set mycell = worksheets("info").range("G2")
with activecell
.numberformat = "mm/dd/yyyy"
.value = dateserial(year(mycell.value), month(mycell.value), 1)
end with
wrote:
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
--
Dave Peterson
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]