Posted to microsoft.public.excel.programming

Robert[_30_] Robert[_30_] is offline

external usenet poster

Posts: 44

VBA, copy unique values

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
copy unique values to validation list	[email protected]	Excel Programming	2	September 27th 07 07:51 AM
Copy rows with unique values to another sheet	vmed	Excel Programming	5	July 29th 06 08:18 PM
Compare and copy unique values	sa02000	Excel Worksheet Functions	1	June 12th 06 09:42 PM
copy only unique values	Sweetetc	Excel Worksheet Functions	2	April 3rd 06 10:42 PM
Copy & Paste Unique Cells Values	jindon[_3_]	Excel Programming	0	June 1st 05 12:14 PM

All times are GMT +1. The time now is 07:01 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us