R
Roz2459
In Lotus you were able to select the paste area before copying the data. Is
this possible in Excel
this possible in Excel
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike H
Hi,
Tell us precisely what you used to be able to do in Lotus123 because the
Excel method of selecting a bunch of cells with the mouse and tapping CTRL+c
sounds remarkably like what your saying Lotus could do.
Mike
Tell us precisely what you used to be able to do in Lotus123 because the
Excel method of selecting a bunch of cells with the mouse and tapping CTRL+c
sounds remarkably like what your saying Lotus could do.
Mike
M
Mike H
Hi,
I misread your post. I don't know of any way of selecting a paste area
before you copy the cells in Excel.
Mike
I misread your post. I don't know of any way of selecting a paste area
before you copy the cells in Excel.
Mike
D
dhstein
You could specify a Range of cells - for example $AA$1:$AC$1000 and put that
range in another cell like Z1. Then in a macro you could copy whatever cells
you need and paste in the range defined in cell Z1. You can also check out
the "Indirect" function or "Index" function. I'm not sure exactly what
you're trying to do, but it is likely that you can do it with macros or those
functions.
range in another cell like Z1. Then in a macro you could copy whatever cells
you need and paste in the range defined in cell Z1. You can also check out
the "Indirect" function or "Index" function. I'm not sure exactly what
you're trying to do, but it is likely that you can do it with macros or those
functions.
D
Dave Peterson
You could use a macro and ask for each of the ranges in any order you like.