Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro help needed
Ok I am using a macro currently, it copies selected cells from roughl
30 sheets and pastes in another workbook. I went to modify or re-record teh macro and now its telling me copy no allowed on multiple selections? Not quite sure whats up. Thank -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro help needed
If you can do it manually, then generally you can do it with code. If you
can't do it manually, then generally you can not do it with code. Look at the macro that worked and modify either that macro to do what you want or adjust your new macro to operate similarly. It would be hard to make a more pointed recommendation without seeing the pertinent code (the code around the area where you are getting an error). -- Regards, Tom Ogilvy "djackson " wrote in message ... Ok I am using a macro currently, it copies selected cells from roughly 30 sheets and pastes in another workbook. I went to modify or re-record teh macro and now its telling me copy not allowed on multiple selections? Not quite sure whats up. Thanks --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro help needed
You need to post the code and highlight where the problem lies.
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "djackson " wrote in message ... Ok I am using a macro currently, it copies selected cells from roughly 30 sheets and pastes in another workbook. I went to modify or re-record teh macro and now its telling me copy not allowed on multiple selections? Not quite sure whats up. Thanks --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro help needed
the highlighted section of the code is listed below.
Sheets(Array("26", "27", "28", "29", "30", "31", "WTD 1", "WTD 2" "WTD 3", "WTD 4", _ "WTD 5", "MTD")).Select Replace:=Fals -- Message posted from http://www.ExcelForum.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro help needed
If you copy from grouped sheets, you need to paste to an identical selection
of grouped sheets. This doesn't sound like what you are doing. -- Regards, Tom Ogilvy "djackson " wrote in message ... the highlighted section of the code is listed below. Sheets(Array("26", "27", "28", "29", "30", "31", "WTD 1", "WTD 2", "WTD 3", "WTD 4", _ "WTD 5", "MTD")).Select Replace:=False --- Message posted from http://www.ExcelForum.com/ |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro help needed
Try looping through the array a sheet at a time
For Each sh In Sheets(Array("26", "27", "28", "29", "30", "31", "WTD 1", "WTD 2", "WTD 3", "WTD 4", _ "WTD 5", "MTD")) ' do your thiung Next sh -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "djackson " wrote in message ... the highlighted section of the code is listed below. Sheets(Array("26", "27", "28", "29", "30", "31", "WTD 1", "WTD 2", "WTD 3", "WTD 4", _ "WTD 5", "MTD")).Select Replace:=False --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro needed | New Users to Excel | |||
VBA Macro needed | Excel Discussion (Misc queries) | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) |