..I'm trying to copy a cell range in a cell, then copy down that cell without
the range changing in each cell. It seems to automatically drop down the
range per cell. Does this make sense?

Geo

Switch between relative, absolute, and mixed references
1.. Select the cell that contains the formula.
2.. In the formula bar , select the reference you want to change.
3.. Press F4 to toggle through the combinations. The "Changes To" column
reflects how a reference type updates if a formula containing the reference
is copied two cells down and two cells to the right.


Formula being copied

Reference (Description) Changes to
$A$1 (absolute column and absolute row) $A$1
A$1 (relative column and absolute row) C$1
$A1 (absolute column and relative row) $A3
A1 (relative column and relative row) C3


--
Don Guillett
SalesAid Software

"Pass Codes" wrote in message
...
.I'm trying to copy a cell range in a cell, then copy down that cell
without
the range changing in each cell. It seems to automatically drop down the
range per cell. Does this make sense?

Geo

.I'm trying to copy a cell range in a cell, then copy down that cell
without
the range changing in each cell. It seems to automatically drop down the
range per cell. Does this make sense?

If I understand what you are saying, just add the $ in front of the
column/row letter/numbers for the range after copying it into the cell but
before copying that cell down. That is, if your copied range is this...
C2:D14, just change it to $C$2:$D$14 after copying it into the cell, then
copy the cell downward.

Rick

try indirect("A1")

or show what u got so far


"Pass Codes" skrev:

.I'm trying to copy a cell range in a cell, then copy down that cell without
the range changing in each cell. It seems to automatically drop down the
range per cell. Does this make sense?

Geo

Yes. It makes sense.

Excel by default will increment as you copy because of Relative referencing.

=A1 + B1 copied will become =A2 + B2

Absolute referencing treats the cells differently.

$A1 will keep the column but change the row.

$A$1 will keep both row and column same.

A$1 will keep row the same but incease the column as you drag across.

To change these around, select the references in the formula bar then cycle
through the options using the F4 key.


Gord Dibben MS Excel MVP

On Sun, 3 Jun 2007 12:21:01 -0700, Pass Codes
wrote:

.I'm trying to copy a cell range in a cell, then copy down that cell without
the range changing in each cell. It seems to automatically drop down the
range per cell. Does this make sense?

Geo