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