Thread: copy/paste
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Kilmer[_2_] Bob Kilmer[_2_] is offline
external usenet poster
 
Posts: 71
Default copy/paste

Dim m As Long
Dim n As Long

Range("C" & CStr(m) & ":D" & CStr(n)).Select
Selection.Copy
Range("F2").Select
ActiveSheet.Paste


"Lee" wrote in message
...
In macro, the following will do copy and paste, but what
is I need the index 7 and 14 below to be a variable?

Range("C7:D14").Select
Selection.Copy
Range("F2").Select
ActiveSheet.Paste