Problem with advancedfilter macro

[ChrisMattock]

Good morning Ladies and Gentlemen,

I have a little macro, it takes data from one sheet (SHEET_IMPORT_ORACLE), pastes it to another (SHEET_PROJECT_LEADERS), sorts the data then makes a list of unique values in Column D of this list. It all works great, except when I try and hide column A, then it drops out with:

Run time error '1004':

The extract range has a missing or illegal filename.

When debug is selected the last paragraph of code is highlighted. Any ideas?

And if you'd like to make my code any prettier I'd appreciate it too!

Please Login or Register  to view this content.

[mudraker]

At what point in the code are you trying to hide column A?


You should always declare your variables - Suggest you read
http://www.ozgrid.com/VBA/variables.htm



I am not sure I interperted you code correctly but this will give you an idea on how you can reduce the need for selecting sheets, cells etc

When copying values it is quicker to populated the range with the values rather copy & paste specials

Please Login or Register  to view this content.