in cell editing macro
 

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

check out absolute vs relative cell referencing in the help/
if you make the first equation be
=$B$1*$B$2
whenever you copy and paste, it will still reference these same two cells.
the macro you are trying to write is not extremely simple and depends on how
you want to call it.


"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

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