Posted incorrect question earier.

Try again




Code please to align wording in a cell such as:

For c = 1 to 1000
If cell Ec is greater than 0 the wording in cell Cc is aligned right,
other wise wording in cell Cc is aligned left.

Thanks in advance

Ed English

Sub Align()

Dim rng As Range, c As Range
'
Set rng = Range("e1:e1000")
For Each c In rng
If c 0 Then
c.Offset(0, -2).HorizontalAlignment = xlRight
Else
c.Offset(0, -2).HorizontalAlignment = xlLeft
End If
Next c
End Sub


HTH

"ED" wrote:

Posted incorrect question earier.

Try again




Code please to align wording in a cell such as:

For c = 1 to 1000
If cell Ec is greater than 0 the wording in cell Cc is aligned right,
other wise wording in cell Cc is aligned left.

Thanks in advance

Ed English