Go to next cell with a value?

[jjokol]

One column contains an IF statement [ =IF($A12=1,IF($F12=3,3,""),"") ] that provides a value of 3 if true. There are 20000 rows in this column and only a few values are 3 so how do i jump from one 3 to the next one without having to page down?

I've tried some VBA in a macro:

Do While IsEmpty(ActiveCell.Value) = False
ActiveCell.Offset(1, 0).Select
Loop
End Sub

But this searches the whole column until the IF statements stop. Then it stops. How do I tell it to look for cells that are not empty even though they all contain the If statements?

I don't want to hard code the value 3 because it needs to be changed.

 

[SkipVought]

Hi,

Youf problem is that NO cell in your column of formulas is "empty" They ALL contain formulas!!!

Rather test for the value of 3.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Loomah]

you don't say what you want to do when you find a 3 which could influence the method you use to find them.

why can't you just filter the list?

alternatively have a look at the vba find method and set the lookin argument to xlvalues

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[SkipVought]

I agree with Loomah. Use the AutoFilter!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}