Bypassing clipboard using Range.Resize [Excel 2010]
I've been using the method/function described here excelexperts.com/copy-values-vba#comment-3417 (I tried posting the actual link but it triggered the spam filter!)
My core report from our database comes out with a different work order status per tab (20 columns but variable rows) and I've been using the function described at the above link to collate all the seperate tabs onto a single one rather than using copy/paste. Everything has been working fine until this week I got a run-time 1004 error. Stepping through the code it breaks when it reaches a tab that contains more than approx. 27200 rows; 27000 works fine with no errors. The weird thing about it is that it actually copies the 27200 rows across but then won't proceed. To say I'm stumped is a bit of an understatement! Any ideas what might be causing it?
I've been struggling with the
I've been struggling with the using the same copy values technique and getting the same generic error. After a of head scratching it turned out to be a cell containing "=" as the first character. Once the data was cleaned up the code ran fine again.