macro selecting datalabel

[Jerry Koch]

Hi.

I am trying to write a macro that selects text inside a
datalabel, because I would then like to copy it to a cell,
so that I can work with it. Does anybody know how to do
this?

Thanks in advance
Jerry.

 

[Dick Kusleika]

Jerry

Like this?

Range("a1").Value = Sheet1.Label1.Caption