Tab not passing on merged cell

[RJ1969]

Hello

These cells below are unprotected cells.

H8,AC11,C16,C18,O18,G20,C22,F32,J34,J36,E43,F47,U43,V47,R33,W16,Y21,B40,B41,Q40,Q41,B52,B53

Y21 and R33 are merged cell. Y21:H22 and the R33:AI36.

When I press the tab from H8 to Y21, I can't get pass tabbing to the next cell.


Please advice.

Thanks.

[AliGW]

This is a known issue with merged cells (there has been another thread on this issue this week). The only workaround is not to use merged cells,

[RJ1969]

Hi
How about a simple tab order vba codes ?

[AliGW]

As I said, the way round this is not to use merged cells.

Here's that other thread: https://www.excelforum.com/excel-gen...-problems.html

[RJ1969]

Thank you.