Run-time error '1004' ; AutoFilter Method of Range class failed

**BorisMKD** · 10-20-2008, 04:13 AM

Hello guys,

I need your help. I lost 2 days trying to discover the bug in my program, but I coudn't find the right answer.

How can I activate the AutoFilter to show me the rows selected with "YES" ?

This is the code... The compiler stops always at the command Selection.AutoFilter.

Thanx, Boris

Please Login or Register  to view this content.

**Stuie** · 10-20-2008, 04:19 AM

Hi BorisMKD,

Have you tried specifing a range to auto filter instead of selection.

eg.

Please Login or Register  to view this content.

**royUK** · 10-20-2008, 04:25 AM

I have deleted the response until Boris adds Code Tags.

**BorisMKD** · 10-20-2008, 04:30 AM

Dear RoyUK,

sorry for 'breaking' the forum rules. I really didn't know about putting code-tags. Could you put the response back, please ?

Thanks

**royUK** · 10-20-2008, 04:44 AM

Originally Posted by BorisMKD

Dear RoyUK,

sorry for 'breaking' the forum rules. I really didn't know about putting code-tags. Could you put the response back, please ?

Thanks

I have restored the reply, hopefully you have read the rules now.

**BorisMKD** · 10-20-2008, 04:52 AM

I did. It shows me the same error all the time...

How can I change this ? Any Ideas ? Please help !!!

**Stuie** · 10-20-2008, 04:57 AM

how about adding

Please Login or Register  to view this content.

changing the A:A to the column(s) you need

**royUK** · 10-20-2008, 05:00 AM

Try this

Please Login or Register  to view this content.

If you still get an error then probably your data layout is at fault

**BorisMKD** · 10-20-2008, 05:07 AM

I've pasted my workbooks in ''C:\My Documents''. Now I get error Subscript out of range
Don´t know why. Please help me

**royUK** · 10-20-2008, 05:12 AM

What do you mean by

I've pasted my workbooks in ''C:\My Documents''.

?

Attach your workbook here so that we can look at it.

**BorisMKD** · 10-20-2008, 05:18 AM

Thans a lot

**royUK** · 10-20-2008, 05:21 AM

It's caused because your data is not laid out for AutoFilter. To use AutoFilter the data has to be in a table layout with a Header, with no empty rows or columns. You will find that a manual filter will fail on your current layout.

**BorisMKD** · 10-20-2008, 05:31 AM

I may not change the form of this table and I really don´t know what do you mean with setting the data in a table layout with a Header.
But I know that I really need to make this table work for keeping my job. So if you know how to help me, then please do it.
After that I need to improve the code as well, because this macro has to make more things, like showing the cell values from Area (1 2 3 4) like (1234) in my second workbook

So RoyUK, please, please help me. I´m trying more than 3.5 weeks to get the right answer.

Thanks, Boris

**royUK** · 10-20-2008, 05:33 AM

You simply cannot use AutoFilter with the data laid out like that

**Stuie** · 10-20-2008, 05:35 AM

BorisMKD are you not able to format the table in a more data friendly way

**BorisMKD** · 10-20-2008, 05:36 AM

Is there any other way to make this macro work ?

Thanks, Boris

**royUK** · 10-20-2008, 05:40 AM

I've altered the sheet so that the code will work.

**BorisMKD** · 10-20-2008, 05:41 AM

to Stuie:

No, I have to keep this form of table. We use the first table like standard in the company. So it cannot be changed at all.
But do you have any suggestions?

Thanks, Boris