I have the simplest question ever. Why can I not declare this
variable? I think if you can give me a good answer you will solve my
confusion on declaring constants..

Dim cht As Object

cht = Sheets("Cheet4").ChartObjects("Chart 5").Chart


Thanks and sorry I post so many questions...

If you declare a variable as an object (including range or worksheet or workbook
or...), then you have to use the Set command:

Set cht = ....

R Tanner wrote:
>
> I have the simplest question ever. Why can I not declare this
> variable? I think if you can give me a good answer you will solve my
> confusion on declaring constants..
>
> Dim cht As Object
>
> cht = Sheets("Cheet4").ChartObjects("Chart 5").Chart
>
> Thanks and sorry I post so many questions...

--

Dave Peterson

It ius an object, so needs setting

Set cht = Sheets("Cheet4").ChartObjects("Chart 5").Chart


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"R Tanner" <(E-Mail Removed)> wrote in message
news:fec9f996-46c8-40b9-abb8-(E-Mail Removed)...
>I have the simplest question ever. Why can I not declare this
> variable? I think if you can give me a good answer you will solve my
> confusion on declaring constants..
>
> Dim cht As Object
>
> cht = Sheets("Cheet4").ChartObjects("Chart 5").Chart
>
>
> Thanks and sorry I post so many questions...

Your current code is using cht as a property of the "Chart 5". If you are
just wanting the Chart Property returned use this below.

Dim cht As Chart

cht = Sheets("Cheet4").ChartObjects("Chart 5").Chart

If you want cht as a Chart Object then use this:

Dim cht As ChartObject

Set cht = Sheets("Cheet4").ChartObjects("Chart 5")

Ryan



"R Tanner" wrote:

> I have the simplest question ever. Why can I not declare this
> variable? I think if you can give me a good answer you will solve my
> confusion on declaring constants..
>
> Dim cht As Object
>
> cht = Sheets("Cheet4").ChartObjects("Chart 5").Chart
>
>
> Thanks and sorry I post so many questions...
>

The value of a Constant is defined when you write the code. You can't modify
the value of a constant at run time. Moreover, your code is missing the Set
statement which is required when you assign any sort of object to a
variable.

Dim CHT As Excel.Chart
Set CHT = Worksheets(1).ChartObjects(1).Chart ' Note 'Set' keyword
Debug.Print CHT.Name

Without the 'Set' keyword, VBA will attempt to find the Default property of
the Chart object, and I don't think there is a default property of a Chart
object.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)





"R Tanner" <(E-Mail Removed)> wrote in message
news:fec9f996-46c8-40b9-abb8-(E-Mail Removed)...
>I have the simplest question ever. Why can I not declare this
> variable? I think if you can give me a good answer you will solve my
> confusion on declaring constants..
>
> Dim cht As Object
>
> cht = Sheets("Cheet4").ChartObjects("Chart 5").Chart
>
>
> Thanks and sorry I post so many questions...