Cells(#,#).Value conversion

[Alexandre Brisebois (www.pointnetsolutions.com)]

Hey I want to grab a serialized date and turn it into an integer in my
vba
what is the proper conversion for this ?

example:

Dim startDate As Integer
Dim endDate As Integer

startDate = ActiveRow.Cells(1, 2).Value
endDate = ActiveRow.Cells(1, 3).Value

 

[Bob Phillips]

A date is already an integer, just format it as General.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Alexandre Brisebois (www.pointnetsolutions.com)"