PDA

View Full Version : How to insert required rows instead of a single row



keentolearn
10-18-2008, 02:41 AM
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
10-18-2008, 04:49 AM
"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