Bails

My advice about merged cells.........

Merged cells are the spawn of Satan!

They cause more problems with Excel than any other feature I can think of.

Copying, cutting, pasting, sorting, filtering are all adversely
affected by merged cells.


Gord Dibben MS Excel MVP

On Fri, 7 Jul 2006 06:29:02 -0700, Bails
wrote:

I have created a form that allows users to only tab to the next input cell.
This works fine until the form comes to two input cells adjacent to each
other that are formed from merged cells. The Tab then gets locked moving
between these two cells rather than moving onto the next cell in the form.

Do a need to write some code to get over this and if what is it?

many thanks in advance

Gord Dibben MS Excel MVP