Macro copy and paste = blank worksheet

I'm creating a macro and it's not functioning the same once I use it.

I first sort a column by a number range, click the top left corner, copy the data, insert a new sheet, and then i paste it. While I create the macro everything is fine. But when I use the macro, it does everything I told it, it copies the header but none of the data, it's completely blank. Does anyone know what i am doing wrong? Here is the VMB code

Please Login or Register  to view this content.

well i solved my own problem.

So i will post the solution incase anyone else needs it.

the column was formatted as text and not numbers. So it would not let me filter numbers.