Macro to insert rows based on user selection Options??

**mike.magill** · 01-25-2010, 05:22 AM

I have a macro that allows a user to insert one or more rows based on
a user input box. This allows me to control which formulae get copied
into the new cells.

The macro works fine UNLESS the user scrolls around the screen before
making their selection. How can I resolve this?

This is the key part of the script.

Thanks,

Mike

Please Login or Register  to view this content.

etc.etc.

**rwgrietveld** · 01-25-2010, 05:43 AM

Please read the forum rules. There you'll find that your code need to be place between CODE TAGS. Do this

HTML Code:

**contaminated** · 01-25-2010, 05:50 AM

.......................

**pike** · 01-25-2010, 08:08 AM

Hi mike.magill
you can limit the scroll area

Please Login or Register  to view this content.

**mike.magill** · 01-25-2010, 09:43 AM

Originally Posted by pike

Hi mike.magill
you can limit the scroll area

Please Login or Register  to view this content.

Hi Pike,

Thanks for the help.

Unfortunately I don't want to limit the scroll area. I want them to be able to scroll down while the script is running in order to reveal the area where they want to insert rows (if not already visible on screen). The macro works fine if they don't scroll but, as soon as the user scrolls, the macro completes but does not insert any rows.

Any more help would be gratefully received.

Thanks