that is required as 'm pasting the values in sheet 2. so i have defined the sheet2.

what? This is the sequence

Q: I get error...

A: Its because...

?: that is required

You're getting an error, you may require that it simply works, but you're getting an error ... now you have to figure out why, wrong API call, wrong version of office, something else ... Worksheets(1) is returning undef, you have to figure out why,

I don't have excel