Search results

Just for the record, changing the order and calling the sort first does not work. Won't even work if I take the others out. Minimacro that calls the mainmacro, then the others did not work either. I can live with it, just thought it might be something obvious that I was overlooking. This...

It's a very nifty macro. Help yourself. It's not mine. I googled it long ago and got it from a forum somewhere. I usually try to note where it came from, but missed it on this one. I use it all the time. I did turn off the screen updating in it, but I think that's the only change I made to it...

Certainly. Each of these are separate modules, all in one workbook. Thanks! Sub SortWorksheets() Dim N As Integer Dim M As Integer Dim FirstWSToSort As Integer Dim LastWSToSort As Integer Dim SortDescending As Boolean Application.ScreenUpdating = False SortDescending = False If...

This is the end of a module where I am calling (attempting to call) three other modules to finish up. Everything works fine except the sort worksheets line. If I take it out all is good. When I add it, the code won't even run. I get the expected procedure not module error. It's a module...

Oh, just found it! I knew it would be simple. On existing pivot table, open the Pivot Table Wizard. Click BACK. That will go back to the data source dialog box. Then, I just extended the range to size I need now. I would think a completely new source could be re-entered here. Thanks again!

Have a similar question. I have a pivot table based on a 'Summary' sheet. I have appended new data to the Summary. How can I get the pivot table to now pull from the entire Summary rather than just the original section? Yes, I can re-create a new pivot table, but surely that's not necessary. I...