Copy noncontigous cells to next sheet
I'm trying to copy the values from A1 and C1 (only)
to my next sheet (sheet2) into cell A1:B1
Sub foo()
Dim Qcell As String
Dim Jcell As String
Qcell = ActiveCell.Address(0, 0)
Jcell = ActiveCell.Offset(0, 2).Address(0, 0)
????????
|