View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JMay JMay is offline
external usenet poster
 
Posts: 468
Default 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)
????????