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?
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?
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?
>
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?
> >
Try Application.ScreenUpdating = False????
put it somewhere in the beginning of your code...
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
>
>
A more effective alternative would be to write your code so it doesn't
select and activate.
--
Regards,
Tom Ogilvy
"havocdragon" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks