Quote:
Originally Posted by c991257
But it was only for the Fill 1. All the others were quick.
|
It only happened on that sheet because it happened to be the only sheet with a single line of data. Any other sheet, at some future point, having only one line of data would have been v. slow too. Now it shouldn't happen at all.
Quote:
Originally Posted by c991257
One of my confused Engineers is running on a mac. There the old code gives him an error 448. Any idea what that is?
|
I strongly suspect that if you were to remove:
, searchformat:=False
including that leading comma, it would work on a mac.