From: Safia on
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.
From: Gord Dibben on
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 <Safia(a)discussions.microsoft.com>
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.