Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying discontiguous ranges to Word
Hi All:
Thanks from this newbie to previous helpers. Current problem: I am trying to copy two discontiguous rectangular ranges to Word. Doing this manually with ctrl-click works just fine. Problem 1: I have a range say "$F$42:$F$51,$H$42:$H$51" in MyRange (note that column G is not included), created by a Union command. A call to myRange.Copy ends up with error 4001 "Cannot change merged cell". True, the second range does have merged cells, but I'm stuck with them. However if I do MyRange.Select then Selection.Copy, there is no error and it works (sort of-- see below). Any idea why? Now to Problem 2: When I paste the selection into Word, I get all the columns between the two ranges, so I get in effect "$F$42:$H$51". Any suggestions? As ever, thanks for your time Garry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deselect a cell in a discontiguous range | Excel Discussion (Misc queries) | |||
Is it possible to plot discontiguous cells? | Charts and Charting in Excel | |||
Is it possible to plot discontiguous cells? | Excel Discussion (Misc queries) | |||
Code for Printing Discontiguous Ranges | Excel Programming | |||
discontiguous ranges in charts | Excel Programming |