in cell editing macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top