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
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