About Us

Don Guillett

Glad to help.

--
Don Guillett
SalesAid Software

"Dooley007" wrote in message
ups.com...

Don Guillett wrote:
You didn't post YOUR code for comments but maybe this will help
ar=activecell.row

range(cells(ar,"a"),cells(ar,"m")).copy

--
Don Guillett
SalesAid Software

"Dooley007" wrote in message
ups.com...
The records in my data are from Column s "A" to "M" inclusive. My code
selects the record I want in
"A(x)" where (x) is of course the row number. I now want to copy the
entire record from "A(x)" to "M(x)" and paste it to a separate
workbook,

How do I select the entire record for copying since the row number can
be any row in my database.

Dooley

Don;

That was exactly what I needed! The code works perfectly!

Sorry I didn't post my coding but you managed to decipher what I
needed.

Thank you very much! I appreciate yoour help.

All ;the best in the New Year to you and yours!

Dooley

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Selecting the latest record for transactions	ahmedzia	Excel Discussion (Misc queries)	4	September 2nd 09 02:36 PM
Selecting Last Record	NWO	Excel Discussion (Misc queries)	5	October 9th 08 02:41 AM
Copying record value from column in multiple sheets into single sh	Harish Sharma	New Users to Excel	4	March 11th 08 11:30 PM
Selecting record to edit using ADO	Ken Valenti	Excel Programming	6	September 24th 06 10:59 PM
Copying Formatting Without Selecting	Dan Gesshel	Excel Programming	0	August 20th 03 01:12 AM

Menu

About Us