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

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/

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/

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

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/

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/