find function not working with merged cells



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

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.

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