Thanks for the code..

I was not too clear in my original question, I'm working up a spread
sheet where I want the wording in column C cells to be aligned right
if there is a plus number value in the corresponding E cell, otherwise
the wording in column C is aligned left.

I thought that putting the following in C1:

=If(E1>0,myRng.HorizontalAlignment = xlRight,myRng.HorizontalAlignment
= xlLeft)


would set the alignment right in C1, then the the wording I put in C1
would be aligned right.

It doesn't seem to work. Any comments?




On Tue, 21 Jun 2005 13:21:17 -0500, Dave Peterson
<ec35720@netscapeXSPAM.com> wrote:

>Since you're writing about wording, are you using e1 to control another cell?
>
>If yes, how about something like:
>
>Option Explicit
>Sub testme01()
>
> Dim myCell As Range
> Dim myRng As Range
>
> With ActiveSheet
> Set myCell = .Range("e1")
> Set myRng = .Range("f1")
> End With
>
> If myCell.Value > 0 Then
> myRng.HorizontalAlignment = xlRight
> Else
> myRng.HorizontalAlignment = xlLeft
> End If
>
>End Sub
>
>
>
>ED wrote:
>>
>> Code please to align wording in a cell such as:
>>
>> If cell E1 is greater than 0 the wording in cell is aligned right,
>> other wise wording in cell is aligned left.
>>
>> Thanks in advance
>>
>> Ed English