Display alert messge when a column is inserted in a range

[Ravana]

Hi all,


I have a range A1:IA100. I would like a prompt message like " please follow the syntax" when I insert a column between "A" and "IA".

Is is possible?

[cytop]

Excel does not raise any events other than the normal Change when columns or rows are inserted/deleted.

The easiest way to do this is to define a named range somewhere outside the range you want to check, and then in the Change event, check that named range is stil in the column/row you defined it in.

[djbomaha]

Hi,

Here is an example of some code that may work. It uses the Worksheet Change Event and checks to see if the value in BA1 has changed, it if has, it alerts. It will change if columns are added/deleted in the range you are describing.

Please Login or Register  to view this content.

Thanks,

Dan

[Ravana]

@ djbomaha


Thanks, that helped.