I have a set of input data in (say) A2 to A4. Formula in A5 and A6 and
input data in A7 to A9. Rows 5 and 6 is hidden. Row numbers and column
headings are also hidden.
The user types data into A2 and then drags to A9, in this process he
overwrites that formula in rows 5 and 6. If I protect rows 5 and 6 then
the standard excel error pops up.
How can I drag the input values without overwriting the formula?
--
Bonzo123
------------------------------------------------------------------------
Bonzo123's Profile:
http://www.excelforum.com/member.php...o&userid=24182
View this thread:
http://www.excelforum.com/showthread...hreadid=378035