Hi Holger,
Sorry, I don't have a problem in this line. I have inserted it in the code and it's working fine. I have a problem in the code to transfer the value of column 'b' to column 'ag'.
I don't want to trouble you friends. I have not completed any vba course. I'm learning it from you and forum friends time to time.So I'm facing the problems. I have learned a lot of things from you to speed up my work quickly using vba. So please don't mind.

Sorry and thank you.

Regards,

Mukesh