Good evening Sam

Change the C1:C10 to $C$1:$C$10. The "dollar" mark will lock either
the rows, or columns, or both depending on which one it appears before.
You don't need to type them in either, just arrow somewhere into the C1
and press F4 - this will cycle through all the options before returning
it to normal.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=516398