Simple Macro Question !

  • Thread starter Thread starter Bob Vance
  • Start date Start date
B

Bob Vance

--
What would I need for Offset Macro in B1 to copy A1
(-1,0).Copy?




Thanks in advance.........Bob Vance
 
Hi Bob,

To copy from cell B1 to A1, Try:

With Range("B1")
.Copy .Offset(0, -1)
End With

To copy from cell A1 to B1, Try:

With Range("A1")
.Copy .Offset(0, 1)
End With
 
range("b1").value=range("a1")
or
range("b1").value=range("b1").offset(-1)
or
range("a1").copy range("b1")
 
Sorry I wanted to be a ActiveCell. Offset so I could use it anywhere on the
sheet to copy the cell above....TIA Bob
 
Back
Top