Thread: TopLeftCell.Address for buttons from forms toolbar
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika[_2_] Dick Kusleika[_2_] is offline
external usenet poster
  
Posts: 66
Default TopLeftCell.Address for buttons from forms toolbar
Andy wrote:
Hi All

Is there an equivalent of:

Set rng = Range(ActiveSheet.Buttons(Application.Caller). _
TopLeftCell.Address)

for buttons from forms toolbar?

Set rng = ActiveSheet.Buttons(Application.Caller).TopLeftCel l

works for me.


--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com



Reply With QuoteReply With Quote