Try using the checkbox control in the Forms menu or a validation since this
single reference serve as an ON/OFF switch for a whole column and an IF
function might help.


jdunnisher wrote:
I have several columns of numbers being used in various calculations on a
spreadsheet. I would like to place a check box at the top of each column and
be able to select or de-select the checkbox to determine whether or not the
numbers in that particular column are included in the calculations. Can
anyone assist me with a macro that would accomplish this?

--
Message posted via http://www.officekb.com