Range.Find with merged cells

I keep getting completely random results using the .find method with a sheet containing merged cells:

I've tried all combinations of
xlpart, xlwhole
xlvalues, xlformulas
expanded the range to include the merged cells
set range as all column A, column A & B

but I can't get it to work consistently, if at all.

I could get it to work if I searched the whole sheet without specifying a range, however there are likely to be more instances over time so I don't want it to find them as it will screw up the range.

I know merged cells are an absolute pain, however they need to remain that way in this case.

Thanks

Little amendment to your code

Please Login or Register  to view this content.

You also need to format your dates to year or month. The code will not find 12 or 2015.

Merged cells are paid in the a**. The only way I can get to work this code is:
First unmerge cells, find the value (Address) and then once you are done, you can re-merge them.

Please Login or Register  to view this content.