Application Object Properties and Find Function

[somnath6309]

Dear Friends,
Please find enclosed herewith an excel file that shows a code that merge all the worksheet data in an active workbook to a new sheet. I have some questions in some lines of the code which i have presented in tabular form. Kindly vide the attachment to view the code and kindly provide an explanation if possible.

Regards,
Somnath

 

[NARAYANK991]

Hi Somnath ,

The following links may help answer some of your questions :

https://www.udemy.com/blog/excel-vba-find/

http://www.siddharthrout.com/2011/07/14/find-and-findnext-in-excel-vba/

http://www.globaliconnect.com/excel...ookup-find-date&catid=79:excel-vba&Itemid=475

http://analysistabs.com/excel-vba/fasten-code-application-objects/

Narayan