Excel 2000 VBA problem -- sorting values in subtotaled column
 

I copied a data table from the internet into an Excel 2000
spreadsheet. I have done this before. Last time, I
experienced trouble, and someone sent me a macro that
cleans up the column being subtotaled so that Excel can
perform calculations. This worked, and I was able to sort
the column after running the subtotal function, so I could
order the subtotals in descending order.
For some reason, my macro isn't working! I have opened the
macro and everything seems to be accurate for the columns
in my new spreadsheet, but.... it still won't let me sort
the subtotals.
Please help! I can send along the file with the macro if
it will help -- drop me an email and I'll reply.
Thank you!
Pemily