Reading formulae results instead of formulae

[AlexPDEBMan]

Hi

I have some VBA code that loops through a selection of rows to check for a certain value. The actual rows of data I am looping through are worksheet formulas. Is there any way I can use VBA to read the cells as the results of the formulae instead of the actual formulae itself? I know I could just copy and paste values over the cells before I loop through them but I don't want to do that!

Cheers

 

[craig.penny]

Suppose you're looping through like

For Each oCell in Selection.Cells
...
Next oCell

I think what you want to check is

oCell.Value

Does that work for you?

 

[AlexPDEBMan]

Hi craig.penny

That does work for me. Thank you very much. It seems pretty obvious now!

 

[craig.penny]

I'm happy it worked for you!