Yes, it is ... use $C1:$C65535 as Sloth suggested

Make the range absolute so that it doesn't increment

$C$1:$C$65535 and $D$1:$CD65535

Regards

Trevor


"SamGB" wrote in
message ...

Isnt $C1:$C65536 and $D1:$D65536 a column anyway?

What i want to do is copy the formula into alot of decending cells, but
every time i copy down a cell the value increases by one which is what i
WANT. However the range also increase by one which i DONT want. Any
ideas??


--
SamGB
------------------------------------------------------------------------
SamGB's Profile:
http://www.excelforum.com/member.php...o&userid=31263
View this thread: http://www.excelforum.com/showthread...hreadid=516363