Next Cell

Hello,

I have a for each that moves from cell to cell in one column. And what i want is, when the for each is in one cell i want to know what is the value of the cell underneath, because if is a determined value i have to block the cell where the for each is placed.

Thanks

post the code u are using.....

Use the .Offset property of a cell to return the value of the cell underneath it.

VB Code:

MyValue = MyCell.Offset(1, 0).Value