Macro to change formula?

  • Thread starter Thread starter Victor Delta
  • Start date Start date
V

Victor Delta

In a series of cells (in an Excel 2002 worksheet), I have a long formula of
the type '=IF(xxxxxxxxxxxxxxxxx,xxxxxxxx,cell ref)' - the functions are
unimportant. The cell ref is usually something like T89 (i.e. three
characters) but could possibly go up to, say, AA101.

I frequently need to change the formula to simply '=cell ref'.

Would it be possible for a macro to automate this process please?

V
 
Victor Delta said:
In a series of cells (in an Excel 2002 worksheet), I have a long formula
of the type '=IF(xxxxxxxxxxxxxxxxx,xxxxxxxx,cell ref)' - the functions are
unimportant. The cell ref is usually something like T89 (i.e. three
characters) but could possibly go up to, say, AA101.

I frequently need to change the formula to simply '=cell ref'.

Would it be possible for a macro to automate this process please?
Click to expand...

Just thought, the cell ref is actually that of 2 cells to the left i.e. in
V89 you would find the formula ending in T89. That might be an easier way on
which to base the macro.

V
 
Just thought, the cell ref is actually that of 2 cells to the left i.e. in
V89 you would find the formula ending in T89. That might be an easier wayon
which to base the macro.

V
Click to expand...

Record a macro while doing a EDIT Replace. Then clean it up and apply
only to specialcells with formulas.
 
Just thought, the cell ref is actually that of 2 cells to the left i.e. in
V89 you would find the formula ending in T89. That might be an easier way
on
which to base the macro.

V

Record a macro while doing a EDIT Replace. Then clean it up and apply
only to specialcells with formulas.
Click to expand...

Thanks, sorted.

V
 
Back
Top