I have some problem, so i have an excel that have a macro script inside it. the macro have to be written in cell like formula before running (Add in). the problem is, if i read cell/range that excell. the cell who using that macro always return wrong values.
sample exact values i want ‘Lima Puluh Tiga Juta Tiga Ratus Lima Puluh Delapan Ribu’
but the return value is ‘-2146826259’
format file excel ‘.xlsm’
Screenshoot :
@aliaga this error usually comes when that cell give #n/a value
so in that case you will need to make update in macro to check whether reference cell isblank if yes keep currentcell value empty else the formula (“proper”)