Take a look here

http://peltiertech.com/WordPress/200...ecorded-macro/

FWIW, you asked for Brief and then to explain in depth. You can't have it
both ways.

HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"RAVI" wrote:

could you please give a brief explanation about the code produced by
recording the macro.

Request you to explain in depth...