| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I use Sort to alphabetize & leave blank row bet. rows (2003) | New Users to Excel | |||
| How do I sort collumns and leave out pictures in rows not used? | Excel Worksheet Functions | |||
| Can I sort values only & leave orginal cell formatting? | Excel Discussion (Misc queries) | |||
| Can I sort in Excel and leave the formatting (color) in place? | Excel Discussion (Misc queries) | |||
| Can you sort text in a column, but leave cell color alone? | New Users to Excel | |||
Linear Mode
