Sort Function

[tian0020]

I'm setting up a public function that sorts after i add an item

Please Login or Register  to view this content.

This function works on the other sort i've done on the GOV sheet, but now it doenst work here.

Any ideas why this wouldnt work. It says that it is a select method of range class failed error.

Thanks

[rylo]

Hi

Try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

HTH

rylo

[tian0020]

Thanks for getting back to me.

Please Login or Register  to view this content.

This one works... however this one still doesnt

Please Login or Register  to view this content.

It is basically the same, however the second one comes up with errors. Any ideas?

[rylo]

Hi

I'd assumed that you were actually on ws2 when running the macro. If you are not then try

Please Login or Register  to view this content.

rylo