Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    May 2001
    Location
    Omaha, NE USA, Nebraska, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Move new worksheet to far right (Excel 97/SR2)

    As a second question that builds on this <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=xl&Number=54774&page=0&view =expanded&sb=5&o=7&part=> thread </A>. How can I move the new worksheet to the end of the already existing worksheets. The help file says that the worksheets.add method will place the new worksheet to the left of the active worksheet. I would like to move it to the far right of any existing worksheets.

    Thanks in advance for any help

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Move new worksheet to far right (Excel 97/SR2)

    <pre> Worksheets("Sheet1").Move after:=Worksheets(Worksheets.Count)
    </pre>

    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •