Prev: Cannot get the column to total with =sum
Next: Font Color Conditional Formatting/Color Scaling
From: Safia on 4 Mar 2010 13:01
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 4 Mar 2010 13:48
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.

 | 
Pages: 1
Prev: Cannot get the column to total with =sum
Next: Font Color Conditional Formatting/Color Scaling