Forgot to send a big thank you. The script is great, but even better is the Ctrl-Alt-R utility you pointed me to. Now I've got back the ability to perform the simplest tasks in the simplest manner. Thanks again for your time and help!
I will try the code above, but that will only effect the one sheet. I had already tried copying and pasting value only data to a new sheet. It appears to be a global Excel problem. When I pull up the sort window on any of the test files the available sort fields extends past column IV (which...
Running Excel 2010.
Something changed when trying to sort. If I choose rows 1-50,000 and try to sort Column K then Column A, I get the warning about effecting a large number of cells and then get memory errors if I go ahead. It looks like it's picking up all the columns rather than...