+ Reply to Thread
Results 1 to 6 of 6

How do I sort values only, and leave formats?

  1. #1
    havocdragon
    Guest

    How do I sort values only, and leave formats?

    Hey All, I have ranges I need to sort constantly and I have programmed them
    all with macros, however, I have alot of formating that falls apart when I
    sort...is there a way similar to pasting special w/values, to sort values
    only?


  2. #2
    Tom Ogilvy
    Guest

    RE: How do I sort values only, and leave formats?

    copy it to another worksheet
    sort the copy
    copy back with pastespecial values.

    --
    Regards,
    Tom ogilvy

    "havocdragon" wrote:

    > Hey All, I have ranges I need to sort constantly and I have programmed them
    > all with macros, however, I have alot of formating that falls apart when I
    > sort...is there a way similar to pasting special w/values, to sort values
    > only?
    >


  3. #3
    havocdragon
    Guest

    RE: How do I sort values only, and leave formats?

    Yeah thats the same idea I came up with =). Thought there might be a better
    way.

    Is there a way to run this macro without forcing the user to sit through the
    light show? For example, they just see the data sort, without watching the
    excel workbook bouncing back and forth through different sheets, or different
    ranges?

    "Tom Ogilvy" wrote:

    > copy it to another worksheet
    > sort the copy
    > copy back with pastespecial values.
    >
    > --
    > Regards,
    > Tom ogilvy
    >
    > "havocdragon" wrote:
    >
    > > Hey All, I have ranges I need to sort constantly and I have programmed them
    > > all with macros, however, I have alot of formating that falls apart when I
    > > sort...is there a way similar to pasting special w/values, to sort values
    > > only?
    > >


  4. #4
    Forum Contributor
    Join Date
    06-21-2004
    Posts
    106
    Try Application.ScreenUpdating = False????
    put it somewhere in the beginning of your code...

  5. #5
    havocdragon
    Guest

    Re: How do I sort values only, and leave formats?

    Awesome that works

    "pikapika13" wrote:

    >
    > Try Application.ScreenUpdating = False????
    > put it somewhere in the beginning of your code...
    >
    >
    > --
    > pikapika13
    > ------------------------------------------------------------------------
    > pikapika13's Profile: http://www.excelforum.com/member.php...o&userid=10892
    > View this thread: http://www.excelforum.com/showthread...hreadid=570875
    >
    >


  6. #6
    Tom Ogilvy
    Guest

    Re: How do I sort values only, and leave formats?

    A more effective alternative would be to write your code so it doesn't
    select and activate.

    --
    Regards,
    Tom Ogilvy


    "havocdragon" <havocdragon@discussions.microsoft.com> wrote in message
    news:9B067BAB-3E24-4948-9231-2E43E2648469@microsoft.com...
    > Awesome that works
    >
    > "pikapika13" wrote:
    >
    >>
    >> Try Application.ScreenUpdating = False????
    >> put it somewhere in the beginning of your code...
    >>
    >>
    >> --
    >> pikapika13
    >> ------------------------------------------------------------------------
    >> pikapika13's Profile:
    >> http://www.excelforum.com/member.php...o&userid=10892
    >> View this thread:
    >> http://www.excelforum.com/showthread...hreadid=570875
    >>
    >>




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1