Thanks Heera,

actually i have worked with VB6 before but now just trying to catch up with
excel's methods a bit.
thanks for the site address
MM

"Heera" wrote:

try and record macro on this procedure if in case there is some error
in the code post it and some one call solve it for you....its not a
dificult marco to right.

Use the site to learn basic of macros.

http://www.angelfire.com/biz7/julian...ans_macros.htm