| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to copy formulas to other cells in excell
am having problems copying formulas from one cell to another using relative
cell references,i have tried several techniques and still does not work,like EDIT,COPY,PASTE SPECIAL,FORMULAS and DRAGGING THE FILL HANDLE but it still refers to the address used in the copied.I want to be able to copy formulas to other cells without encountering this problem. |
|
#2
|
|||
|
|||
|
Have you tried this with a VBA solution for a selected range ? JAck -- Jack in the UK ------------------------------------------------------------------------ Posted via http://www.mcse.ms ------------------------------------------------------------------------ View this thread: http://www.mcse.ms/message1352492.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy formulas - strange things happens | Excel Discussion (Misc queries) | |||
| how do i copy vertical formulas to horizonal and keep same cell r. | Excel Discussion (Misc queries) | |||
| how do I make a copy of a worksheet and retain formulas but not data | Setting up and Configuration of Excel | |||
| In Exel 2000, stop the blank cells (with formulas) from printing. | Excel Discussion (Misc queries) | |||
| delete values in several cells without deleting the formulas | Excel Discussion (Misc queries) | |||
Linear Mode
