Hi<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
<o
> </o
>
Using Excel VBA I am looking to automate a basic Copy and Paste routine which amounts to little more than copying row 3 and then pasting it in the next blank row below.<o
></o
>
<o
> </o
>
However I want the User to decide on the “number” of rows they want pasting into the Worksheet based on an input box.<o
></o
>
<o
> </o
>
Based on this “number” the macro will copy row 3 find the next blank row and copy row 3 the applicable “number” of times as determined by the User.<o
></o
>
<o
> </o
>
E.g. <o
></o
>
Run Macro<o
></o
>
Input Box asks User how many rows they would like pasting?<o
></o
>
User Inputs “50”<o
></o
>
Macro copies Row 3 and then pastes row 3 into the next blank row 50 times over<o
></o
>
<o
> </o
>
Any help would be much appreciated?<o
></o
>




<o


Using Excel VBA I am looking to automate a basic Copy and Paste routine which amounts to little more than copying row 3 and then pasting it in the next blank row below.<o


<o


However I want the User to decide on the “number” of rows they want pasting into the Worksheet based on an input box.<o


<o


Based on this “number” the macro will copy row 3 find the next blank row and copy row 3 the applicable “number” of times as determined by the User.<o


<o


E.g. <o


Run Macro<o


Input Box asks User how many rows they would like pasting?<o


User Inputs “50”<o


Macro copies Row 3 and then pastes row 3 into the next blank row 50 times over<o


<o


Any help would be much appreciated?<o

