Hi,
I need to combine multiple workbooks to in one sheet am using the below mention code for combining but that is not finding the all sheest of a work book. Kindly give a sugesstion for me.
![]()
Please Login or Register to view this content.
Hi,
I need to combine multiple workbooks to in one sheet am using the below mention code for combining but that is not finding the all sheest of a work book. Kindly give a sugesstion for me.
![]()
Please Login or Register to view this content.
try![]()
Please Login or Register to view this content.
Last edited by Leon V (AW); 12-16-2013 at 06:52 AM.
You are putting in With ... End With, but then refer to active sheet ranges. Suggested changes:
![]()
Please Login or Register to view this content.
thank you Leon
there is error reflecting "Object does not support this property or method"
Last edited by Liju144; 12-16-2013 at 06:45 AM.
sorry my bad edited
Its Ok thanks for helping to me ..
you have Any other option to that???
Here's an alternative
![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks