Thread: Stretch selection range

Maybe this has been done already and somebody could point me to the correct thread.

I'm making a macro that selects a range, but needs to pause for the user to adjust the height of the range, then resume the macro. There is no way for the macro to anticipate the final range height (number of rows is at the whim of the user, but the number of columns will always be the same).

If there was some way to pause in the middle of the initial selection and let the user finish it, that would seem to be the cleanest to code. Hoping this has already been done!

LonnieP