User Form imported into Named Range

[grumpyoldman]

Hello any help would be appreciated, How can I import a user form to the start of a Named range?
the First cell is at (300,1), I have tried to enter top data far enough down a worksheet but the user form does not show and of course it the freezes waiting for input into form so I cannot see the current position of the form.
thank you for any help.

 

[sijpie]

Not sure what you are trying to achieve. Do you want the sheet to scroll down to row 300 before it shows the userform?

 

[grumpyoldman]

what I was trying to achieve was to to stop a running macro reverting back to a sub routine/routine that had been used earlier, I ended getting around this by using the end command after setting up all the variables for the next key press to set of next macro orders. Thank you anyway.