View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ardus Petus Ardus Petus is offline
external usenet poster
 
Posts: 718
Default copy paste codes

Maybe you need someting like:
Range("A1").Copy destination:=Range("B1")

That will copy contents and format of A1 into B1

HTH
--
AP

"Taru" a écrit dans le
message de news: ...

Could someone tell me some commands that will essentially copy and
paste?
Does cell.offset copy and paste? The help files says that it "returns",
but its only for a specific cell or range. I just need some different
commands for copy and paste


--
Taru
------------------------------------------------------------------------
Taru's Profile:
http://www.excelforum.com/member.php...o&userid=35494
View this thread: http://www.excelforum.com/showthread...hreadid=553332