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.

Hydra wrote:

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

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


On 15-Dec-2009 11:51, Dave Peterson wrote:
Because merged cells are a real pain to work with.