get ActiveCell.Address when a chart is selected

  • Thread starter Thread starter Brian Murphy
  • Start date Start date
B

Brian Murphy

Is it possible to get ActiveCell.Address while a chart on a worksheet
is selected?

Thanks,

Brian
 
A couple of window properties will get it -

For Each wn In ActiveWorkbook.Windows
If Not wn.ActiveCell Is Nothing Then
Set acell = wn.ActiveCell
MsgBox acell.Address & vbCr & _
wn.RangeSelection.Address
Exit For
End If
Next

Obviously if you know an embedded chart item is selected simply
ActiveWorkbook.Windows(2).ActiveCell

But don't do that in 2007, earlier versions only

Regards,
Peter T
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conso macro 0
Pulling out numeric number from Activecell.Address 4
Updating a chart 2
Passing variables in macros 2
Conditional Formatting in 2007 1
File name extension 2
Returning vars to calling sub 4
ActiveCell.Address to return non Absolute reference 5

Back
Top