Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pasting a portion of a Merged Range
Hello all, I hope someone has a solution to my problem out there. I am writing a COM addin for Excel 2000 that gathers data from save workbooks within a given folder. In my addin, it has the capability o pasting portions of the column headings and/or row headings and work fine as long as neither contain portions of a merged range (i.e. m range I am copying is B1:B3 however cell B1 is part of the merged rang of A1:C1). In cases where the MergeCells = True, I divert to a subroutine tha copies the values and then enumerates through each format setting an duplicates that as well. Suffice it to say, the sub really slows things down. Is there quicker way to copy the styles to the new sheet or just copying th cells that I want without having to bring the remaining merged cell with? Unmerging cells is not an option because many of the workbook this addin would deal with are protected. Any help would be greatly appreciated. :cool -- tssop ----------------------------------------------------------------------- tssopa's Profile: http://www.excelforum.com/member.php...fo&userid=1660 View this thread: http://www.excelforum.com/showthread.php?threadid=31469 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting into merged cells | Excel Discussion (Misc queries) | |||
(2003) Pasting into merged cells | Excel Worksheet Functions | |||
Pasting into merged cells | Excel Discussion (Misc queries) | |||
Pasting a portion of an array | Excel Programming | |||
pasting into merged cells with a macro | Excel Programming |