| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy an array of Sheets | Excel Discussion (Misc queries) | |||
| Copy/Paste array formulae from the newsgroup | Excel Discussion (Misc queries) | |||
| Cannot Copy/Paste Array Formula | Excel Worksheet Functions | |||
| Why can't you use this VBA w. array & cell value instead of copy paste? | Excel Programming | |||
| Need help to Copy and Paste array using macro | Excel Programming | |||
![bobwilson[_21_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
