Blank rows script help

[xzile609]

Hello,

How do I change this script so that it works off data in column B instead of column A?

Thank you

Please Login or Register  to view this content.

[alansidman]

Try this:

Please Login or Register  to view this content.

[AB33]

Please Login or Register  to view this content.

[alansidman]

If you want increased flexibility in deciding which column to use then try this code which adds a message box to ask the user which column

Please Login or Register  to view this content.

[AB33]

If you want to insert or delete rows, you need to loop back ward, not forward, as you code has been set-up

[xzile609]

Thanks alan that worked perfect I really appreciate that.

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.