Excel 2007 : Help to Solve Run-time Error 424 "Object Required"

Can you read the forum rules, please, and use code tags around any code you post?

Your problem here is likely to be because Name is a reserved word in VBA, so you shouldn't use it as a variable name.

Dear Andrew-R,

I have changed the variable Name with Nam.

However the problem is remaining same.

In my opinion the problem is due to some other reason

Hope you will help me as i am not as adept in Visual Basic as i am in Excel.

Regards;

D S Rama Rao