Copy noncontigous cells to next sheet
That's it? -- at one point I thought of doing them separately (like this)
but thought there is probably a "fancier way" of combining A1 and C1.
Not so, huh?
Thanks,
Jim
"Gary''s Student" wrote:
Sub foo()
Sheets("Sheet1").Range("A1").Copy Sheets("Sheet2").Range("A1")
Sheets("Sheet1").Range("C1").Copy Sheets("Sheet2").Range("B1")
End Sub
--
Gary''s Student - gsnu200723
|