Simple Macro Question !

[Bob Vance]

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




Thanks in advance.........Bob Vance

 

[Norman Jones]

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

 

[Don Guillett]

range("b1").value=range("a1")
or
range("b1").value=range("b1").offset(-1)
or
range("a1").copy range("b1")

 

[Bob Vance]

Sorry I wanted to be a ActiveCell. Offset so I could use it anywhere on the
sheet to copy the cell above....TIA Bob

 

[Don Guillett]

so change to activecell.copy range("b1") or the other way around.

 

[Bob Vance]

Sorry I am not that clever could you script it for me... Thanks