Can anyone tell me the proper code to copy a range...

's Computer Specifications

dim s as worksheet
set s=thisworkbook.sheets("othersheet")

thisworkbook.Range("A2:M2").copy _
s.cells(s.rows.count,1).end(xlup).offset(1,0)

--
Tim Williams
Palo Alto, CA

"Steel Works, Inc." <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> Can anyone tell me the proper code to copy a range in one worksheet to the
> first available empty row in another worksheet? Thanks!
>
> CB
>
>

's Computer Specifications

Can anyone tell me the proper code to copy a range in one worksheet to the
first available empty row in another worksheet? Thanks!

CB

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
code to copy range	smith82	Microsoft Excel Worksheet Functions	1	2nd May 2010 02:27 PM
RE: Proper syntax for selecting a range using cells instead of range	arjen van...	Microsoft Excel Programming	0	22nd Jul 2009 06:23 AM
Re: Proper syntax for selecting a range using cells instead of range	Per Jessen	Microsoft Excel Programming	0	22nd Jul 2009 06:15 AM
RE: copy range code	Mike H	Microsoft Excel Programming	3	8th Dec 2008 12:46 PM
Code to copy range vs Copy Entire Worksheet - can't figure it out	Mike Taylor	Microsoft Excel Programming	1	15th Apr 2004 08:34 PM