find function not working with merged cells

  • Thread starter Thread starter Hydra
  • Start date Start date
H

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?
 
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.
 
I agree. Merged cells are evil. It's often better to use Center Across Selection.
 
Back
Top