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

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

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

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: [email protected]

[email protected] wrote:
>
> Sorry, The previous has some wrong,

The correct is
StartDate = Sheets("Macro Data").Cells(1,2)
>
>
Aheng
> MSN: [email protected]

You can also do sheets("Macro Data").range("A2")
[email protected] wrote:
> [email protected] wrote:
> >
> > Sorry, The previous has some wrong,
>
> The correct is
> StartDate = Sheets("Macro Data").Cells(1,2)
> >
> >
> Aheng
> > MSN: [email protected]

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


"[email protected]" wrote:

> You can also do sheets("Macro Data").range("A2")
> [email protected] wrote:
> > [email protected] wrote:
> > >
> > > Sorry, The previous has some wrong,
> >
> > The correct is
> > StartDate = Sheets("Macro Data").Cells(1,2)
> > >
> > >
> > Aheng
> > > MSN: [email protected]
>
>

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
>
>
> "[email protected]" wrote:
>
> > You can also do sheets("Macro Data").range("A2")
> > [email protected] wrote:
> > > [email protected] wrote:
> > > >
> > > > Sorry, The previous has some wrong,
> > >
> > > The correct is
> > > StartDate = Sheets("Macro Data").Cells(1,2)
> > > >
> > > >
> > > Aheng
> > > > MSN: [email protected]
> >
> >

Okay. That's helpful. Thanks!

Dan

"[email protected]" 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
> >
> >
> > "[email protected]" wrote:
> >
> > > You can also do sheets("Macro Data").range("A2")
> > > [email protected] wrote:
> > > > [email protected] wrote:
> > > > >
> > > > > Sorry, The previous has some wrong,
> > > >
> > > > The correct is
> > > > StartDate = Sheets("Macro Data").Cells(1,2)
> > > > >
> > > > >
> > > > Aheng
> > > > > MSN: [email protected]
> > >
> > >
>
>