Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a date in both B1 and B2 (sheet "Macro Data"). In my macro, I have the
following code: Dim EndDate As Date Dim StartDate As Date StartDate = Sheets("Macro Data").Cells("B1") EndDate = Sheets("Macro Data").Cells("B2") The above statements are giving me error 13 (type mismatch). What's wrong with my statements? How do I reference the date data in my macro? Thanks! Dan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Type mismatch problem in array - ?? | Excel Programming | |||
Help: Compile error: type mismatch: array or user defined type expected | Excel Programming | |||
Type mismatch error problem when dealing with Strings | Excel Programming | |||
Type Mismatch Problem | Excel Programming | |||
Type mismatch problem? | Excel Programming |