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

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." wrote in message ...
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

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

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