Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel - outlines
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel - outlines
Outline is a applicable to a row and not to a cell. Try and copy the rows
instead. If this post helps click Yes --------------- Jacob Skaria "meghnal" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel - outlines
Hi,
Thanks a lot for your reply. Can you please tell me is there any way to read a complete row/column using microsoft office interop excel. Thanks Meghna "Jacob Skaria" wrote: Outline is a applicable to a row and not to a cell. Try and copy the rows instead. If this post helps click Yes --------------- Jacob Skaria "meghnal" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel - outlines
Try the below
ws2.Rows("5:9").Copy ws1.Rows(5) OR ws2.Rows("5:9").Copy ws1.Rows(5:9) If this post helps click Yes --------------- Jacob Skaria "meghnal" wrote: Hi, Thanks a lot for your reply. Can you please tell me is there any way to read a complete row/column using microsoft office interop excel. Thanks Meghna "Jacob Skaria" wrote: Outline is a applicable to a row and not to a cell. Try and copy the rows instead. If this post helps click Yes --------------- Jacob Skaria "meghnal" wrote: 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel - outlines
Thanks a lot for reply...I think I dint put my question in correct way. I
want to copy not only the data but outline structure as well i.e expand and collapse buttons should alsp occur in the worksheet ws1. Thanks Meghna "Jacob Skaria" wrote: Try the below ws2.Rows("5:9").Copy ws1.Rows(5) OR ws2.Rows("5:9").Copy ws1.Rows(5:9) If this post helps click Yes --------------- Jacob Skaria "meghnal" wrote: Hi, Thanks a lot for your reply. Can you please tell me is there any way to read a complete row/column using microsoft office interop excel. Thanks Meghna "Jacob Skaria" wrote: Outline is a applicable to a row and not to a cell. Try and copy the rows instead. If this post helps click Yes --------------- Jacob Skaria "meghnal" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Outlines in Excel 2007 | Excel Discussion (Misc queries) | |||
Allow expand/collapse of Excel outlines on protected sheets | Excel Discussion (Misc queries) | |||
How do I get Excel to not print blank pages when using outlines | Excel Worksheet Functions | |||
Excel Outlines | Excel Worksheet Functions | |||
Using Outlines in Excel | Excel Discussion (Misc queries) |