You need to record with the target sheet active.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Robert" wrote in message
...
Hello,

Could some one tell me wich VBA statement to use for copying all
unique values from Column A (Sheet2) to Cell A5 in Sheet1?. When I try
to record a macro the system mentiones that it is only possible to do
this in an active sheet.

Many thanks

Regards,
Robert