I was making a report. Some data in different sheet. Did you want to export them in csv data sheet. But it does show error "method union of object _global failed".
Please Login or Register to view this content.
I was making a report. Some data in different sheet. Did you want to export them in csv data sheet. But it does show error "method union of object _global failed".
Please Login or Register to view this content.
Since R1 and R2 are referring to different SHEETS ranges then how you can select different sheets ranges in one shot when only one sheet will be the activesheet?
Why don't you do the copy paste process one by one like
R1.copy
R2.copy
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi, sanju2323,
AFAIR there is no chance to build a multi range for ranges on different sheets in one range (and it doesn´t matter if one of them be the ActiveSheet). Maybe use an Array to loop through the sheets and the ranges.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
I think the above one is directed to me.
If so, my statement should be read based on the below line of OP's code.
Please Login or Register to view this content.
Hi, ;) SixthSense ;)
please give the code with your alteration a try for a RTE 1004 at code line
where the ranges still refer to different sheets. The workaround is to either build individual ranges or use an Array/Collection/String for the areas and copy these individually.Please Login or Register to view this content.
Ciao,
Holger
Is there any easy way to report. will also export to csv or xls format.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks