VBA Code to sort worksheets based on a pre-sorted named-range

Re: VBA Code to sort worksheets based on a pre-sorted named-range

I am not Getting the Error 1004 But I am Getting the Error 9 on the "Sheets(rng(i).Value).Move after:=rng.Parent" Can Any one pls Help to Solve This Problem

Re: VBA Code to sort worksheets based on a pre-sorted named-range

Thanks, Now Am Not Getting The Error 1004 But Now I am Getting Error 9 In The Code " Sheets(rng(i).Value).Move after:=rng.Parent"

Re: VBA Code to sort worksheets based on a pre-sorted named-range

Quote from manoj mailapur;799378

Thanks for Yours Clear Explanation.

Pls Help Me On These Error 9 In Next Page Explination