FInd selected cells in Excel

[solanki2]

I need to find the range of cells that I slect (by highghting using left mouse drag) on an excel worsheet I opened using Labview. I use ActiveX to open the excel file but struggling to get the sected range using ActiveX. WHat I really need to get the cell address of the selcted range for ex. "C2:E5". Appreciate if anyone can give me any tips.

[ben64]

You need to register an Event Callback for the Selection Change event of the Excel._Worksheet object and create a callback vi to pass the reference of the string indicator where you want the range to be displayed. Attached is an example of that.

Ben64

[solanki2]

Dear Ben64,

Thank you very much for the reply. Unofrtunately I haven't got the LabVEIW v17 yet and running V15. If possible can you plese post the examples in V15.

Thanks again.

[ben64]

Version LV2015 attached.

Ben64