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:

dim AmpC as Integer
AmpC = 2 'This is the column with the merged cell

'Please note that "r" is used as a variable to loop through the rows; 
'Also, please ignore the reference to ArrayName and RandomNumber

If ArrayName(RandomNumber, 1) = Sheets("Current Schedule").Cells(r, AmpC).Value Then
    'Do something
Else
    'Do nothing
End If

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