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

