| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying formulas
I am trying to copy a formula in a worksheet that uses a cell that is a
constant in the formula. The cell information keeps changing everytime I copy it. How do I write a formula that will keeps that cells information but change the other portion of the formula to the next line? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copying formulas
Same as in the worksheet without VBA. Use a $ on either the row or column
you do not want adjusted. -- Gary''s Student - gsnu200850 "Greg B" wrote: I am trying to copy a formula in a worksheet that uses a cell that is a constant in the formula. The cell information keeps changing everytime I copy it. How do I write a formula that will keeps that cells information but change the other portion of the formula to the next line? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying formulas | New Users to Excel | |||
| Copying Formulas | Excel Discussion (Misc queries) | |||
| Copying Sum Formulas | Excel Worksheet Functions | |||
| copying formulas in vba | Excel Discussion (Misc queries) | |||
| Copying formulas | Excel Worksheet Functions | |||
Linear Mode
