Dear All,
I was using the below mentioned code to combine several workbooks in single worksheet. However recently i copied this code in my personal macro book (personal.xlsb) and when i run this code from macro option it gives me "Run Time Error 1004" "Copy method of Worksheet class failed"...