edit the cell contents command in Excel 2007 macro

S

Safia

In Excel 2007, I want to write a macor which edits the cell contnets and goes
to right or left adjacent cell and again eidts the cell contents.
Will higly appreciate the suggestion and or s,advice.
Thanks.
 
G

Gord Dibben

Sub test()
With ActiveSheet.Range("B1")
.Value = "middle"
.Offset(0, -1).Value = "left"
.Offset(0, 1).Value = "right"
End With
End Sub


Gord Dibben MS Excel MVP
 
Top