rangefrompoint method to find out excel row & column position

[Ran]

Hi,

I am using OWC excel component and trying to drag&drop a label on to
the spreadsheet and expecting to find the row/column position where the
label was dropped.

I am using code as below :
Private Sub Spreadsheet1_DragDrop(Source As Control, x As Single, y As
Single)
Dim abc As Object

Set abc = Spreadsheet1.ActiveWindow.RangeFromPoint(x, y)


MsgBox TypeName(abc)

End Sub

rangefrompoint() method always reutrn null (nothing). Any ideas on how
to find the row/column numbers?

Thanks

 

[Alvin Bruney - ASP.NET MVP]

i think i had a reply to this a couple weeks ago in here. see if you can
google for it.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET