find function not working with merged cells

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?
 
D

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.
 
R

Rob van Gelder

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

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

Top