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

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

You may copy unique values to an empty area in Sheet2 then MOVE that area to
Sheet1.

Regards,
Stefi

€žRobert€� ezt Ã*rta:

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