Re: Excel problem

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

Jon

Are you using VBA in Excel? Almost have to be. Anyhow, there is a Cells 
collection, I think, for various entities - including a Range - the 
Cells collection is essentially a 2-dimension array, so you use numeric 
row and column Cells(2,3) is the cell in row 2, column C.

You can select a column and walk through it using For Each myCell in 
Range("B") - in myCell you can get the Row and Column properties - to 
get the value of the cell one column to the right and one row down, 
something like

Cells(myCell.Row + 1, myCell.Column + 1).Value or .Text is close - has 
been a while, man!!!

Hope this points you in the right direction.
Vern

Jon Paris wrote:
> Can any of you Excel gurus help me with this.
>
> I need to place a value in column B based on finding an X in column C  
> in the next row.
>
> If the X is not present, then the value in column B should remain  
> unchanged.
>
> I'm sure this must be possible but I'm darned if I can find it.
>
> Also, I have only ever used cell-based formulas - other than VB script  
> or whatever, is there a way to simply write a formula that loops  
> through an entire worksheet?
>
>
> Jon Paris
>
> www.Partner400.com
> www.SystemiDeveloper.com
>
>
>
>