10-18-2012, 05:45 PM
(This post was last modified: 10-18-2012, 06:06 PM by neerndg123.)
Hi Ankesh,
Thanks a lot for your reply. I will check and let you know whether it works or not.
Regards,
Neeraj
Hi,
By following, I am able to search the string I wanted to i.e. today's date in the excel sheet.
It returns correct value. But I want to know the address of the Column+row where it is found. How to do that?
Regards,
Neeraj
Thanks a lot for your reply. I will check and let you know whether it works or not.
Regards,
Neeraj
Hi,
By following, I am able to search the string I wanted to i.e. today's date in the excel sheet.
Code:
intNeer=ExcelWS.UsedRange.Find(MyDate)
It returns correct value. But I want to know the address of the Column+row where it is found. How to do that?
Regards,
Neeraj