Thread: Getting the clicked cell

Hi everybody,

I am programming in C++. After the user clicked on an excel cell I need to idenify it. I get the event "SheetSelectionChange" and I tried the following code:
XL::Range range;
LPDISPATCH lpActiveCell;
lpActiveCell=appExcel.GetActiveCell();
range.AttachDispatch(lpActiveCell);

How can I get the coodrinates (e.g. D12) from the range?

Thanks,
Vaclav

You should be able to use the VBA function ActiveCell.Address to return the address for a single cell, or Selection.Address for a range. Or are you doing something more complex?

Originally Posted by malkusm

You should be able to use the VBA function ActiveCell.Address to return the address for a single cell, or Selection.Address for a range. Or are you doing something more complex?

I am programing with C++ (VS 2003) and cannot use any VBA functions.