| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
