Re: $$Excel-Macros$$ Fine tuning a code to insert rows

change this see if that helps ActiveCell.Resize(numrows-1).Insert On Wed, Feb 23, 2011 at 9:06 AM, petee wrote: > I have a spreadsheet where I need to copy a row and have EXCEL > automatically copy new rows based on a number inputted by the user > (less 1). > > I've used a code which was previo

$$Excel-Macros$$ Fine tuning a code to insert rows

I have a spreadsheet where I need to copy a row and have EXCEL automatically copy new rows based on a number inputted by the user (less 1). I've used a code which was previously posted that creates a box asking how many rows I need. This works fine but the problem is that people often input one ro