Dear Sir,

Thank you very much for helping.
your all codes work fine
Here is another question

How to apply following format in range(a1:d2)

@Z 9,99,999.99

Please help again