Type mismatch problem
 

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

Type mismatch problem
 

Instead of:
StartDate = Sheets("Macro Data").Cells("B1")

Try:
StartDate = Sheets("Macro Data").Cells("B1").Value


--
C01d
------------------------------------------------------------------------
C01d's Profile: http://www.excelforum.com/member.php...o&userid=34422
View this thread: http://www.excelforum.com/showthread...hreadid=546956

Type mismatch problem
 

Dan wrote:
My English is very bad. I hope you can understand what I say .

The type of "CellS()" is wrong. The Correct is "Cells(row,column)"

StartDate = Sheets("Macro Data").Cells(2,1)
EndDate = Sheets("Macro Data").Cells(2,2)

or you can use

StartDate = Sheets("Macro Data").Range("B1")
EndDate = Sheets("Macro Data").Range("B2")

Aheng
MSN:

Type mismatch problem
 

wrote:

Sorry, The previous has some wrong,

The correct is
StartDate = Sheets("Macro Data").Cells(1,2)


Aheng
MSN:

Type mismatch problem
 

You can also do sheets("Macro Data").range("A2")
wrote:
wrote:

Sorry, The previous has some wrong,

The correct is
StartDate = Sheets("Macro Data").Cells(1,2)


Aheng
MSN:

Type mismatch problem
 

When I use

StartDate = Sheets("Macro Data").Range("B1").Value

it works. If I use

StartDate = Sheets("Macro Data").Cells("B1").Value

I get the type mismatch error. This is my first attempt to use macros in
Excel. What is the difference between Range and Cells?

Dan


" wrote:

You can also do sheets("Macro Data").range("A2")
wrote:
wrote:

Sorry, The previous has some wrong,

The correct is
StartDate = Sheets("Macro Data").Cells(1,2)


Aheng
MSN:

Type mismatch problem
 

Cells requires the row/col co-ordinates - see the examples above, range
will allow a text string
Dan wrote:
When I use

StartDate = Sheets("Macro Data").Range("B1").Value

it works. If I use

StartDate = Sheets("Macro Data").Cells("B1").Value

I get the type mismatch error. This is my first attempt to use macros in
Excel. What is the difference between Range and Cells?

Dan


" wrote:

You can also do sheets("Macro Data").range("A2")
wrote:
wrote:

Sorry, The previous has some wrong,

The correct is
StartDate = Sheets("Macro Data").Cells(1,2)


Aheng
MSN:

Type mismatch problem
 

Okay. That's helpful. Thanks!

Dan

" wrote:

Cells requires the row/col co-ordinates - see the examples above, range
will allow a text string
Dan wrote:
When I use

StartDate = Sheets("Macro Data").Range("B1").Value

it works. If I use

StartDate = Sheets("Macro Data").Cells("B1").Value

I get the type mismatch error. This is my first attempt to use macros in
Excel. What is the difference between Range and Cells?

Dan


" wrote:

You can also do sheets("Macro Data").range("A2")
wrote:
wrote:

Sorry, The previous has some wrong,

The correct is
StartDate = Sheets("Macro Data").Cells(1,2)


Aheng
MSN: