| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
See help file on absolute cell reference
"ynissel" wrote: I tried recording a macro that edits a cell and copied the formula from in that cell and pasts it elsewhere. This was I can copy a formula without the specific cell referenced in the cell changing. i.e. cell A1 contain =b1*c1. If I just copy to a2 the formula would change to b2*b3 but if I edit cell a1 - select all then copy and then go to a2 and paste - it would still read b1*b2 which is what I want. When I record the macro - it doesnt recognize what Im trying to do. Any ideas ? Thanks, Yosef |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell color index comparison | New Users to Excel | |||
| Insert text in a cell with a macro | Excel Discussion (Misc queries) | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| show macro security setting in a cell | Excel Worksheet Functions | |||
| Relative Macro Help on Keystrokes | Excel Discussion (Misc queries) | |||
Threaded Mode
