Hi all,
While executing the macro in some columns am getting formulas instead of getting values of that formulas...
Like for example am getting like
=RIGHT(RC[-1],2)&"/"&MID(RC[-1],5,2)&"/"&LEFT(RC[-1],4) instead of the values...
Can anyone help me to solve this issue..
Thanks in advance....
While executing the macro in some columns am getting formulas instead of getting values of that formulas...
Like for example am getting like
=RIGHT(RC[-1],2)&"/"&MID(RC[-1],5,2)&"/"&LEFT(RC[-1],4) instead of the values...
Can anyone help me to solve this issue..
Thanks in advance....