macro selecting datalabel
 

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.

macro selecting datalabel
 

Jerry

Like this?

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

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Jerry Koch" wrote in message
...
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.