Walter A. March wrote:
Thanks Kevin... those are good suggestions. The original point, that
M$ Excel has an automated way to do this, is still valid. I was
researching today and came across this one:
http://www.oooforum.org/forum/viewtopic.phtml?t=38775
but I don't know enough Basic (yet) to understand whether it would do
what we want or not. Anyone?
I don't believe it does what you want, but it's probably a good starting
point. It's designed to copy only the visible cells in a single
continuous selection and will emit an error if there are multiple
selected ranges.
Ross
Thanks :)
WalterAM
kevin johnston wrote:
The general answer is "not directly". But there is a workaround.
There are four scenarios, based on two conditions:
1. The source data is scattered, but it is in a region that is
*otherwise empty* except for the data that you want to copy
*AND*
The destination is a currently-empty area.
- This one is easy, just copy a single contiguous range that includes
all the source data you actually want, and paste it in the
destination area.
2. The source data is scattered among other data; you only want to
copy some of it
*AND*
The destination is a currently-empty area.
- This one is also easy, but not a single step: Copy a single
contiguous range that includes all the source data you really want
(and possibly other data that you don't want), paste it into the
destination area, then delete the data you didn't want to copy.
3. The source data is scattered, but it is in a region that is
*otherwise empty* except for the data that you want to copy
*AND*
The destination is *not* empty; you only want to overwrite certain
cells with new data from the source area, and you want other data in
the destination area to remain undisturbed.
- Select and copy a single contiguous range that includes all the
source data you actually want.
- Select the destination area you want to copy into.
- Now do Edit->PasteSpecial->SkipEmptyCells.
4. The source data is scattered among other data; you only want to
copy some of it
*AND*
The destination is *not* empty; you only want to overwrite certain
cells with new data from the source area, and you want other data in
the destination area to remain undisturbed.
- The procedure here is a combination of 2 and 3.
- First copy a single contiguous range containing all the source data
you really want, and paste it into some temporary blank region. Go
through the temporary region deleting out the data you didn't really
want to copy.
- Now copy (or cut, since you probably won't be needing the temp
region afterwards) the temporary region, which is empty except for
data that you really want to copy, and Paste Special into the real
destination region.
PasteSpecial->SkipEmptyCells works just like a normal Paste if you
select a destination range bigger than the source range: It repeats
the source data in the destination range. This can achieve some very
useful results.
Kirill S. Palagin wrote:
Hello.
Is there a way to copy noncontinuous selection? I can select
noncontinuous cells just fine, but Copy command is not available.
Thanks a lot.
WBR,
K. Palagin.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
