How to insert required rows instead of a single row

[keentolearn]

Hi,

Is it possible to have a macro that prompts me to enter number of rows required to insert. After the answer is given the rows are to be inserted above the last data row in column B.

Thank you.

[GTO]

"Is it possible..."

Absolutely yes.

"After...last data row..."

We would need to know: is (1) the 'data row(s)' are contiguous (no skipped rows), and/or,(2) is there any other data below the 'data rows' (such as another 'table' or other data). Basically, you'd like a reasonably accurate method of discerning tha actual last row.

Mark