Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
copy formula down a column and have cell references change within formula | New Users to Excel | |||
Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |