VBA, copy unique values

[Robert]

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

 

[Bob Phillips]

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)

 

[Stefi]

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

Regards,
Stefi

„Robert†ezt írta: