Hi

The error I getting is

Run-time error '13'
Type mismatch

When I click on debug the following line getting an error.

UniqueHeaders Application.Index(d, 1, 0)

However I have identify that header in some of excel sheet is not same but I need to consolidated the data from all workbook. Please help me.


Quote Originally Posted by Admin View Post
Hi rocky,

Welcome to ExcelFox!!

Please explain what kind of error you got and at which line ?