Error on range selection in macro

Hey guys.

I got a problem and I just cannot find a solution to it.
What I want my code to do is:
1. Autofilter a list
2. Select all values in column "B" in the filtered list
3. Copy it to another sheet.

The code runs when I change a ComboBox and the combobox value is the criteria used in the autofilter.

Here is my code so far:

Please Login or Register  to view this content.

The code crashes when I try to Copy filtered range.
I get this error message:

Run-time Error '1004':
Method 'Range' of object '_Worksheet' failes

I get this error no matter what I do there.
Even when I try something like this it still fails:

Please Login or Register  to view this content.

Any ideas? The sheet or workbook isnt password protected or anything.


UPDATE:

If I make a new macro with the code:

Please Login or Register  to view this content.

and use the Call function to run that code it all works fine.
Very weird.

What column is being autofiltered? Column A? Column C?

If it's column C, maybe something like this, notice we don't do any selecting or "activecell" referencing, VBA doesn't need to evaluate cells the way humans do, it can simply act if you give complete reference to the object(s):

Please Login or Register  to view this content.

I'm sure that will need some tweaking. Perhaps the sheet being copied to (underlined) is another sheetname, edit that.

If you can't figure it out, post a copy of your workbook so we can look at the same thing. Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your workbook.