Hi All,

I have a copy/paste macro which adds one line to several sheets. I am trying to build code to allow a user to enter a number by input box which will call my copy/paste macro x times until the number of lines matches the number entered by the user. I have used a countif function to determine how many rows in a cell in my worksheet but am not sure how to assign this number to be compared with the number inputed by the user in the input box.

Your help is greatly appreciated.

Best,
Mel