Removing TM1 formulae from a sheet
Posted: Fri Jul 13, 2018 5:23 pm
Hi
I've been using a macro that I found online to replace TM1 formulae with values. It searches for the formulae beginning with "=DBRW" and "=-DBRW" and various other combinations, which so far has been working great.
However I've now got DBR within IF formulae, and the true/false conditions will change for each cell (leaving and I can't account for every combination within the macro).
Does anyone have any tips on how I can get around this?
I thought about "tagging" the start of each formula with =N("TM1")+ which would return a 0 value, and then having the DBR formula after it, However this only really works for numbers. So something like:
=N("TM1")+IF(A1=B1,DBRW(XXXXX),"OK")
would return 0OK. Also thought about =IF(N("TM1")=0,"","")& but this will only work for strings and not numbers.
I've been using a macro that I found online to replace TM1 formulae with values. It searches for the formulae beginning with "=DBRW" and "=-DBRW" and various other combinations, which so far has been working great.
However I've now got DBR within IF formulae, and the true/false conditions will change for each cell (leaving and I can't account for every combination within the macro).
Does anyone have any tips on how I can get around this?
I thought about "tagging" the start of each formula with =N("TM1")+ which would return a 0 value, and then having the DBR formula after it, However this only really works for numbers. So something like:
=N("TM1")+IF(A1=B1,DBRW(XXXXX),"OK")
would return 0OK. Also thought about =IF(N("TM1")=0,"","")& but this will only work for strings and not numbers.