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
|