How can I paste a sheet manytime over

[manii]

I would like to past a sheet over and over again with out having to do each page over and over again .. can sombody please help me

Manii

 

[ajetrumpet]

you can use a macro. say, for example, I have one sheet in my workbook, and I want to past 50 copies of it, one sheet after another in the workbook. I would use this macro in the WORKBOOK module:

dim i as long

for i = 1 to 50
  sheets(i).copy after:= sheets(i)
next i

YOU CAN ALSO DO THINGS LIKE RENAMING THE NEW SHEET WHEN IT'S CREATED AND SUCH. CHECK OUT THE HELP MENU FOR THIS KIND OF STUFF. JUST REMEMBER THAT THE SHEET COUNT STARTS AT 1 FOR THE BASE, NOT 0 (SOME OBJECTS IN VB START THE BASE AT 0 FOR THE ELEMENT COUNTS IN THE COLLECTIONS). ALSO REMEMBER THAT SHEET 1 STARTS AT THE LEFT SIDE OF THE BOOK AND GOES RIGHT INCREMENTALLY.

 

[Datsmart]

Hi Manii,

It is a little vague as to exactly what you are asking.

These steps will copy a worksheet to as many new worksheets as you want:

1. Click the corner square left of the A and above the 1 and hit Ctrl-c to Copy the active worksheet to your clipboard.
2. Hit Shift-F11. (Creates new worksheet)
3. Hit Ctrl-v to paste.

Repeat Shift-F11 and Ctrl-v as desired.

 

[manii]

Thank you Adam.. that is what I wanted to do , only i was hoping for a method that did not need a macro..

And thanks to you john for your help .. only that method gets a bit tiring after 256 time ..

Thanks again

Manuel

 

[Smitty]

Welcome to the Board!

only that method gets a bit tiring after 256 time ..

VBA is your only option in this case.

Note that you can create a programmatic failure trying to copy too many sheets at once.

See: http://support.microsoft.com/kb/210684

HTH,

 

[ajetrumpet]

i don't think you can do it without a macro, but good luck!

 

[manii]

thanks for the help .. I am bit new to excel .. i guess I will have to learn How Excel macro works ..lol.

Tahnks again

Manuel