Error Using filters "Method of range class failed"

So, I'm trying to use a filter to get a certain type of data for an entire column. I want the macro to operate so that it works for as long as the column goes, because number of data points would change often for my uses. When I tried to run the macro I got an error:

"Run time error '1004':
Auto Filter method of Range class failed"

My code is:

Please Login or Register  to view this content.

and it is the first line "Selection.AutoFilter" which gives the error

whoa thanks alot, that worked like a charm. Do you mind explaining what the error was and how that code fixed it?

Also, If i want to create a corresponding column of numbers going up by some integer, but then stopping when there are no more values in the original column, how would i do that?

For example, say i have a column like this:

3.4
5.4
5.4
2.3
1.2
4.5
2.1
5.3

I want to create a column next to it that goes up in integers, for example going up in 5s:

5
10
15
20
25

In code, along with the other set of code, all in one macro

It starts in the same row as the pasted column from the autofilter, which is now row 2. The column used to determine the last row is also the pasted column from the autofilter.

nvm, thanks for all the help, i figured out how to do the 2nd part