find function not working with merged cells

[Hydra]

I'm using the find function to locate the column in which data is located.
Some of the columns have merged cells. Searching row wise the function finds
the first 8 targets and then skips over the ninth one, which is in merged
cell.

however it finds the target in column four, which is also a merged cell.

The find function is searching for values, not formulas and my target text I
"$".

Any reason why it is missing some targets?

 

[Dave Peterson]

Because merged cells are a real pain to work with.

I've seen routines that use simple find/findnext and compare with the first
address found (like VBA's help shows) go into endless loops because of the way
the find fails with merged cells.

 

[Rob van Gelder]

I agree. Merged cells are evil. It's often better to use Center Across Selection.