Reference Merged Cell Value

Hello All,

The issue that I am having is with merged cell data. What I am trying to do is check the value of the merged cell against a selection from an array and place the value into a cell.

What apparently occurs is that if the row that I am on is an even number (being as my rows start on an odd number); the reference returns empty. I have tested to confirm that this only affects even numbered rows.

My spread sheet has a 2 row merged cell in column 2, and the cell I am referencing from is on the second row of that merged cell.

Here is some code:

Please Login or Register  to view this content.

So the issue only occurs when "r" is the second row used in the merged cell

Anyone see how I can still be able to reference the value contained in the merged cell? I would also like to note, that testing has proven that when "r" is the first row used in the merged cell, there is no issue with referencing it's value