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?

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?

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?

How do I sort values only, and leave formats?
 

Try Application.ScreenUpdating = False????
put it somewhere in the beginning of your code..

--
pikapika1
-----------------------------------------------------------------------
pikapika13's Profile: http://www.excelforum.com/member.php...fo&userid=1089
View this thread: http://www.excelforum.com/showthread.php?threadid=57087

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

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" wrote in message
...
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

How do I sort values only, and leave formats?
 

Thanks Tom this works out great.

Just out of curiosity, how would I do this if the array values were in a
range of cells?

"Tom Ogilvy" wrote:

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

--
Regards,
Tom Ogilvy


"havocdragon" wrote in message
...
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