Problem with Find function

S

Snedker

Hope some fresh eyes might help! :)

With this line

Set endCell = ActiveSheet.Range("B15:B19").Find(0, LookIn:=xlValues)

I try to find the value 0 in the range of B15 to B19. I have tried to
enter 0 in both all and either of the 5 cells, but no matter what it
returns Nothing for the varialble endCell.

The range B15:B19 is formatted as number with 2 digits.

Regards
Snedker
 
V

Vasant Nanavati

No trouble with Excel 2002:

?ActiveSheet.Range("B15:B19").Find(0, LookIn:=xlValues).Address
$B$17

Is this statement in a function rather than a macro? Problems have been
reported using Find within a UDF, mostly with Excel 97.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I can't reference a cell as the criteria in the AVERAGEIFS functio 2
Code does not error but no copy either 4
Create Detail Sheets from Pivot Table 1
cell copy question 3
If Then in VBA, check cell, enter data to other cell 6
MAX in VBA not working 5
Transpose dynamic range 3
Compile error. Need Help with this UDF !!!!!!!!!!!!!!! 3

Top