Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
get ActiveCell.Address when a chart is selected
Is it possible to get ActiveCell.Address while a chart on a worksheet
is selected? Thanks, Brian |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
get ActiveCell.Address when a chart is selected
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 "Brian Murphy" wrote in message ... Is it possible to get ActiveCell.Address while a chart on a worksheet is selected? Thanks, Brian |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
get ActiveCell.Address when a chart is selected
Thank you, Peter. I will give that a try.
Brian On Nov 5, 4:40 pm, "Peter T" <peter_t@discussions wrote: 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 "Brian Murphy" wrote in message ... Is it possible to get ActiveCell.Address while a chart on a worksheet is selected? Thanks, Brian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveCell.Address question | Excel Programming | |||
How can i get activecell address | Excel Programming | |||
activecell.address problem | Excel Programming | |||
Activecell address | Excel Programming | |||
ActiveCell.Address | Excel Programming |