Pressing 'ENTER' lands me on a cell in a hidden row

[Arty Choke]

I have an Excel spreadsheet with numerous hidden rows.

I find that under normal circumstances with non-merged cells, when I press enter Excel will move down to the cell in the next visible row. It works great.

However, I recently discovered that under some circumstances this is not the case. It appears that if I have merged cells within a row, then Excel does not get me to the next non-visible row... I end up in the next row, even if it is hidden row.

What is worse, is now I am stuck in this cell. Pressing 'ENTER' does not advance me any further. At this point I need to either click on a new cell or use the cursor keys.

What is causing this behavior, and how do I prevent it?

Thanks!
Mike

 

[ebotron]

I recently came up against this same strange issue, this post was all the internet had to offer on it, so I'll post my solution here for future googlers:

Sub workbook_open()

    Application.OnKey "{RETURN}", "thisworkbook.press_down"
    Application.OnKey "{ENTER}", "thisworkbook.press_down"
    
End Sub
Sub press_down()
SendKeys "{DOWN}"

End Sub

This forces enter to behave as the down arrow would- which as far as I can tell fixes the problem.

Thanks,
Phil