View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika Dick Kusleika is offline
external usenet poster
 
Posts: 179
Default 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.