Insert X number of Copied row based on user input

Hi all,

I have a code that prompts the user to state how many rows they need to insert, triggered if the place a "P" in column A.
The code I have works sometimes and not others (pasted below). I think it has something to do if the User inserts a P above where the VBA has already run. Example: if user inputs a P in row 10, runs the VBA, and then tries to input the code in row 3.

The error I get is:

Run-time error '-2147417848 (80010108)':
Method 'Insert' of object 'Range' failed

The code copies the row that the user inputs the P in and copies it down to the number of rows the user inputs. It shifts everything else down so it doesn't copy over existing information.
This macro is posted to the master sheet in the workbook and I am using excel 2010 if that matters.

Any help, or any ideas would be greatly appreciated
Thank you so much.

Please Login or Register  to view this content.

Marc L,

Thank you for responding! I am still running into the same problem (same error). It works the first time I change a cell to P but doesn't work the next time.

The line

Please Login or Register  to view this content.

becomes highlighted

I posted that in the worksheet and ran it, nothing happened. I have other code throughout the workbook if that changes anything

No issue on my side …

Reboot your PC, only open Excel and nothing else then start to try in a new workbook …

And it is not protected