There are 3 options when using Absolute references -the $ sign.
In your case all you have locked is the column - $B198
To lock the complete formula it is written as $B$198
or to lock only the row number it would be B$198
If you select the element B198 and then press F4 yo can cycle betwee
thos 3 options with the fourth option removing all dollar signs
HT
-----------------------------------------------
~~ Message posted from
http://www.ExcelTip.com
~~View and post usenet messages directly from
http://www.ExcelForum.com
~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements