Avoid typing on cell

[gibtoul]

Hello All,

The following code allows me to avoid the AS and AT columns, double entry celll on the same line.

I would like to apply to several other column group:
C with F,
X with Z. ...;

After several unsuccessful attempts I appeal to the forum to help me!

thank you

A soon

Please Login or Register  to view this content.

[DavidJAllen]

gibtoul,

I have modified you code so not more than one cell in a row in ranges C:F, X:Z, AS:AT can be entered.

Please Login or Register  to view this content.

If you need to restrict to the specific columns you stated that are not next to each other (C&F, X&Z) then I can find a solution to that also. Let me know if you need this.

Regards

David