Append "/1000" to formula in cell range

[bound4h]

I am trying to code a macro that will, in essence, divide all values in a non-contiguous range by 1000. BUT, the key is not to overwrite the formula.

Example: I have two ranges A1:C2 and T2:U:9 and all of the cells have a SUMIF() formula in them. Well, using a Combo Box with two choices (one for "in 000's" and one for "Original") I would like the user to be able to select "in 000's" and the macro APPEND "/1000" to the end of all of the formulas in the range. So that when the user then selects "Original" from the combo box it will take OFF the /1000 and the formula will stay in tact.

Is this possible? <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->

 

[SteveO59L]

Rather than modifying the formula, would you not be better off adding a format to display the numbers as required?

 

[shg]

If you had a checkbox control linked to a cell, say A2, then you could change the formulas to be

=sumif(whatever) / if(A2, 1000, 1)