On going formula
 

In Excel 2003 I am wanting to setup a formula where column C minus column B
with the answer in column D.
I wish to repeat this formula in an unknown number of rows where each column
will have a different value, and I also wish to hide the formula.
Can this be done?

Thanks
Stan W.

On going formula
 

Stan,

Are you wanting to do this in the worksheet or using VBA? In the worksheet
wouldn't this just be:

in cell D1: =C1-B1

Then drag down to cover the rows you are interested in. I hope this is not
an oversimplification of what you are doing (it probably is). Let me know if
I am misunderstanding.

As for hiding the formulas, select the desired cells, right click and select
"Format Cells" on the pop-up menu, click the "Protection" tab, check the
boxes for "Locked" and "Hidden", click "OK". Then click "Tools" on the menu
bar and select "Tools" then "Protection" then "Protect Sheet" and click "OK"
on the dialogue box that comes up. This should do it. Again let me know if
I am misunderstanding what you want.

Good Luck!

Brandt

"Stan W." wrote:

In Excel 2003 I am wanting to setup a formula where column C minus column B
with the answer in column D.
I wish to repeat this formula in an unknown number of rows where each column
will have a different value, and I also wish to hide the formula.
Can this be done?

Thanks
Stan W.

On going formula
 

Hi Brandt,

I was trying to find some way of setting the formula and hiding it at the
same time. Your system of hiding the formula after will do exactly what I
want.

Thanks from a "mature age person".
Stan.

"Brandt" wrote:

Stan,

Are you wanting to do this in the worksheet or using VBA? In the worksheet
wouldn't this just be:

in cell D1: =C1-B1

Then drag down to cover the rows you are interested in. I hope this is not
an oversimplification of what you are doing (it probably is). Let me know if
I am misunderstanding.

As for hiding the formulas, select the desired cells, right click and select
"Format Cells" on the pop-up menu, click the "Protection" tab, check the
boxes for "Locked" and "Hidden", click "OK". Then click "Tools" on the menu
bar and select "Tools" then "Protection" then "Protect Sheet" and click "OK"
on the dialogue box that comes up. This should do it. Again let me know if
I am misunderstanding what you want.

Good Luck!

Brandt

"Stan W." wrote:

In Excel 2003 I am wanting to setup a formula where column C minus column B
with the answer in column D.
I wish to repeat this formula in an unknown number of rows where each column
will have a different value, and I also wish to hide the formula.
Can this be done?

Thanks
Stan W.