Auto Filter & Move

**Sniper** · 12-10-2009, 05:56 AM

I am trying to autofilter a range - what it's suppose to do is to move it to another column. keeps giving me an error. What am I missing here?

Please Login or Register  to view this content.

**royUK** · 12-10-2009, 06:33 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

**Sniper** · 12-10-2009, 08:03 AM

Hi Roy, I went a different route, going with very simple auto filter code. Thanks

**royUK** · 12-10-2009, 08:32 AM

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save