RE: $$Excel-Macros$$ use of find method in VBA

2013-11-06 Thread Ravinder
rutuja patekar Sent: Thursday, November 07, 2013 11:14 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ use of find method in VBA I am taking data from one workbook and finding the same data in different workbook. I am using find method, below is my code; Dim rowcrnt As Range

$$Excel-Macros$$ use of find method in VBA

2013-11-06 Thread rutuja patekar
I am taking data from one workbook and finding the same data in different workbook. I am using find method, below is my code; Dim rowcrnt As Range Dim rng As Object Workbooks(Input1_FileName).Sheets(Input1_SheetName).Activate Workbooks(Input2_FileName).Sheets(Input2_SheetName).Activate Co