edit the cell contents command in Excel 2007 macro
 

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.

edit the cell contents command in Excel 2007 macro
 

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


On Thu, 4 Mar 2010 10:01:01 -0800, Safia
wrote:

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.