Vlookup in a range (or something)

p45cal · #1 07-26-2016, 08:25 AM

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.

p45cal · #2 08-31-2016, 05:05 PM

Quote:

Originally Posted by p45cal

I strongly suspect that if you were to remove:
, searchformat:=False
including that leading comma, it would work on a mac.

Did it work?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find if Date range falls within another range	Triadragon	Excel	3	05-02-2016 11:48 AM
Name a Range in a Word Document and then copy that range to the end of the doc w button click	DanNatCorning	Word VBA	1	04-29-2016 10:47 PM
How to create vlookup formula range R1C1 using VBA	jyfuller	Excel Programming	0	04-29-2015 12:03 PM
Help using If and Vlookup	heastlund	Excel	3	08-04-2014 01:34 PM
VLOOKUP looking at another cell for its range	Rich18144	Excel	1	06-24-2014 07:56 AM