Hi. I am a VBA novice. I have the following problem.
I need users to be able to copy current row to an inserted row directly below the active row in a worksheet using a macro.
However the users may not insert rows above row 11.
Further the users may not insert rows below StopRowInsert (a Range name for the value of rows before row insertions) row 49-1. Therefore if a user insert a row, the Row() value for the row at row 49 would increase to 50 and 50-1 would be the new lower limit for row insertions.
Outside rows 9 and the value defined by the Range name StopRowInsert the macro should not insert rows and prompt the user to select a cell in the allowable range.
The macro I have for the insertion and copy-ing of the row is below.
How can I add the limits and the user message to the macro?
Any ideas and suggestions are welcome. Thanks in advance.
Bookmarks