not copy guides into the Array

[marreco]

Hi.
Anyone, why is it generating error in the code below?

I want to copy many guides, but I can not copy the tabs that are within

Please Login or Register  to view this content.

time error '13 run '
incompatible types

Please Login or Register  to view this content.

[AB33]

Replace
ws1 As Worksheet,

by
ws1

Remove the worksheet, just use ws1

[marreco]

Hi.

Maybe i don't understand you.
I change this line

Please Login or Register  to view this content.

Display error

time error '438 ':
The object does not support this property or method

yellow line

Please Login or Register  to view this content.

[Solus Rankin]

Please Login or Register  to view this content.

Untested.

[AB33]

The error on that line is because you have assigned an array to an object(worksheet), so if you declare the sheet as variant, the line will not error.
Sorry! I did not check the rest of the code.

[marreco]

Hi.

Error '1004 '

The cell or chart that you are using is protected and therefore read-only

Strange, I haven't protected tab


how the file is over 10MB, I posted on
http://www.sendspace.com/file/k1vnb8

[AB33]

In which line of the code do you get the error?

[marreco]

Look
Error

Error '1004 '

The cell or chart that you are using is protected and therefore read-only

Please Login or Register  to view this content.

See my file
http://www.sendspace.com/file/k1vnb8

[Solus Rankin]

Looks like you need to unprotect the sheet first.

[AB33]

Amended code if the protect line works.

My code copies the sheets range in the array in to sheet1.

Please Login or Register  to view this content.

[marreco]

Hi AB33 , sorry, your code copy only one row.

Why my code before, made ​​the copies of all the guides smoothly (with the blocked realação guides), I'm having problems now?

[AB33]

These are your lines

Please Login or Register  to view this content.

It should copy range B11: K and last row in each sheet in the array.
Do you have data in column B which go down to the bottom of it?

[AB33]

Try,

Please Login or Register  to view this content.

[marreco]

Hi.
I need to know one thing, the line below, would be copied guides?

Please Login or Register  to view this content.

as I have many guides, I preferred Array for the tabs that do NOT want to copy


if I try by all guides, generates error 9

Please Login or Register  to view this content.

[AB33]

If the error is "Out of script"
I was unable to access the attached as I do not have the software to download it. Could you please attach it?

I suspect the error is due to one or more sheet names, which are included in the array do not exist on sheet collection. In other words, you have include some names in the array with "", but these names are not on the active book you are working on.

[marreco]

Hi.

look my file..........

[AB33]

For the first part of the code, consider using this code while I will look at your code.

Please Login or Register  to view this content.

[AB33]

I have now found the error on the array. As I said some of the sheet names have typos, 3, not 03, 4, not 04. Some of them do not exist, like 07.

Please check the spelling of each sheet should match to the name you put in to the array.

Please Login or Register  to view this content.

[AB33]

If you get an error "Out of script", It usually means the sheet does not exist in the sheet collection. This could be due to the sheet does not exist, or the spelling on the sheet does not match with the code sheet name. In other words, the sheet does not exist as VBA could not tell if there is a typo.

[marreco]

Hi.

Awesome, very good!
thank you very much!