Hi,
I have to copy data from one excel file to another. I am using the following
command to copy

ws2.get_Range("A1", "D5").Copy(ws1.get_Range("A5","D10"));

ws1 and ws2 are Worksheets. When I copy like this, the rows/cols which were
grouped in ws2 dont appear as group in ws1. Is there any way we can restore
this information.

Thanks in advance
Meghna