Yep, that's the type of of ordering I'm talking about. Personally, I never re-order columns as I always load data to the data model anyway.
...
Interesting approach.
I do have some merges and sorts in the model. For reordering, are you talking about the column order? I try to keep...
In order to get a speed test of a block of code I create a query that performs just the steps I want to analyze, make sure it loads to a worksheet or...
Ken Puls Yesterday, 06:00 PMThat was what I suspected - thanks for verifying!
Now I just have to figure out why my report (45c x 3500r) takes so long to parse.
...
VBA Duplicate Value in Column And Perform Calculation
Try with your revisited code, maybe it's closer to your needs.[CODE]Option Explicit '...
rollis13 Yesterday, 11:58 PM