Automatically insert a new row after inputting data

[lealea1982]

Hello,

I would like a macro that automatically inserts a new row when the user types data (or hits return) on certain rows.

For example, if the user types any data into row 20 I'd like a new (blank) row to automatically be inserted underneath. However, I'd only want this to occur on certain rows and not all of them.

Is this possible?

Many thanks

[tarquinious]

Use something like the following to automatically insert a row when a user changes anything in row 20. You can also use Selection Change to trap if they press enter.

Please Login or Register  to view this content.

[lealea1982]

Perfect, thank you!