Get the row and column number

in reply to Use The Macro Recorder, Luke (Re: Using Win32::OLE and Excel - Tips and Tricks)
in thread Using Win32::OLE and Excel - Tips and Tricks

I am trying to do this is my program. Open an Excel File Search for a value in the excel file When i find the value i want to know the location of that value. For example if my excel file has 3 values A1-->apple A2-->Orange A3-->Grapes When i search the file for orange..it should say that orange found and return me the value A2. I am not able to find the location. Please help

Comment on Get the row and column number

Replies are listed 'Best First'.
Re: Get the row and column number by Corion (Patriarch) on Aug 25, 2007 at 07:56 UTC
Read the Excel object model documentation. For a cell (or Range) there likely is a function returning the coordinates of the upper left corner. Maybe it's `Cell->Address` or something containing `R1C1` in its name.	[reply] [d/l] [select]

In Section Tutorials