Duplicate Declaration error

[xyz123]

Hi

I am getting "Duplicate Declaration" error while running my code. Cant post entire code as its too long but i am pasting the problem line.

Can you please help me?

Please Login or Register  to view this content.

[royUK]

This is because a variable is declared twice within the same procedure.

[xyz123]

[QUOTE=royUK;2000513]This is because a variable is declared twice within the same procedure.[/QUOTE

Yes i know that. But what is the solution. i thought filter(1) and filter(2) are different variables.

[royUK]

This is because a variable is declared twice in the same procedure. I also think the way you have declared the variables fc(1), etc Excel is expecting an array because only the last one is recognised as a string.

You need to declare them like this

Please Login or Register  to view this content.

For an alternative way of doing multiple autofilters take a look here

[xyz123]

This is because a variable is declared twice in the same procedure. I also think the way you have declared the variables fc(1), etc Excel is expecting an array because only the last one is recognised as a string.

You need to declare them like this

Please Login or Register  to view this content.

]

Declaring them like you suggested also give the same error. Any other ideas?

Thanks
j

[royUK]

Can you attach the workbook?

[Andy Pope]

You dimension the array by specifying the bounds.

So rather than 8 mentions use

Please Login or Register  to view this content.

[xyz123]

Can you attach the workbook?

Here we go...

[royUK]

Your data in the sheet does not have a header row, so it won't autofilter correctly anyway.

[xyz123]

Your data in the sheet does not have a header row, so it won't autofilter correctly anyway.

Well as i mentioned earlier this is not original code and original workbook and so there may be little things like that. but the problem is with the error which is correctly reproduced in my sample file.

The header row does not have anything to do with the duplication error. Even after putting a header row it gives the same error.

Do you have any other ideas?

Thanks a lot
J

[VBA Noob]

xyz123,

Please read forum rules below and then add the link to the other excel forum as cross posting without the link is not permitted

VBA Noob

[Leith Ross]

Hello xyz123,

Andy was correct about you needing to create an Array. Unfortunately, that was only the beginning. You had several other errors as well. I have corrected your macro and added it to the attached workbook. Here is the corrected macro code...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[VBA Noob]

Thread closed for not following my request

PM me if you agree to the rules

VBA Noob