Finding Next sheet for copying data

[Liju144]

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.

[Leon V (AW)]

try

Please Login or Register  to view this content.

[Kaper]

You are putting in With ... End With, but then refer to active sheet ranges. Suggested changes:

Please Login or Register  to view this content.

[Liju144]

thank you Leon
there is error reflecting "Object does not support this property or method"

[Leon V (AW)]

sorry my bad edited

[Liju144]

Its Ok thanks for helping to me ..

you have Any other option to that???

[JOHN H. DAVIS]

Here's an alternative

Please Login or Register  to view this content.