Copy Range and Paste to Array of Sheets
 

I have a workbook with 55 sheets. I only want to update 50 sheets.
I want to copy the range A103:X141 from my SheetMaster to all those 5
sheets in the array. I also want to copy the form buttons from th
master to all 50 sheets in the array

--
bobwilso
-----------------------------------------------------------------------
bobwilson's Profile: http://www.excelforum.com/member.php...fo&userid=3304
View this thread: http://www.excelforum.com/showthread.php?threadid=52985

Copy Range and Paste to Array of Sheets
 

Sub ABC()
For i = 6 To 55
With Worksheets("SheetMaster")
.Range("A103:X141").Copy _
Destination:=Worksheets(i).Range("A103")
.Buttons(1).Copy
Worksheets(i).Select
Range("B9").Select
ActiveSheet.Paste
End With
Next i

End Sub

--
Regards,
Tom Ogilvy



"bobwilson" wrote
in message ...

I have a workbook with 55 sheets. I only want to update 50 sheets.
I want to copy the range A103:X141 from my SheetMaster to all those 50
sheets in the array. I also want to copy the form buttons from the
master to all 50 sheets in the array.


--
bobwilson
------------------------------------------------------------------------
bobwilson's Profile:
http://www.excelforum.com/member.php...o&userid=33046
View this thread: http://www.excelforum.com/showthread...hreadid=529855

Copy Range and Paste to Array of Sheets
 

The Code copies the Excel data great however the Buttons are not coping
correctly.
The Buttons(these are form buttons and not control tool box) are not
coping over correctly. Any ideas?


--
bobwilson
------------------------------------------------------------------------
bobwilson's Profile: http://www.excelforum.com/member.php...o&userid=33046
View this thread: http://www.excelforum.com/showthread...hreadid=529855

Copy Range and Paste to Array of Sheets
 

I tested with a forms button. It copied fine for me.

--
Regards,
Tom Ogilvy




"bobwilson" wrote
in message ...

The Code copies the Excel data great however the Buttons are not coping
correctly.
The Buttons(these are form buttons and not control tool box) are not
coping over correctly. Any ideas?


--
bobwilson
------------------------------------------------------------------------
bobwilson's Profile:
http://www.excelforum.com/member.php...o&userid=33046
View this thread: http://www.excelforum.com/showthread...hreadid=529855

Copy Range and Paste to Array of Sheets
 

I have 13 form objects (1 combo box and 12 buttons) on my sheet that I
need to copy. Do you know any reason why it won't work? The Combo Box
is coping to the correct location however all other buttons are not
coping.


--
bobwilson
------------------------------------------------------------------------
bobwilson's Profile: http://www.excelforum.com/member.php...o&userid=33046
View this thread: http://www.excelforum.com/showthread...hreadid=529855