VLOOKUP/MATCH problem

Thread View: pl.comp.lang.vbasic

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Pierre Fichaud Wed, 27 Jan 2010 21:33

#104453

Author: Pierre Fichaud
Date: Wed, 27 Jan 2010 21:33

17 lines
1368 bytes

Hi,
	I'm trying to use a cell in one sheet to find a row in another sheet.

xd = WorksheetFunction.Substitute(cd, "/", "-")
j = Application.Match(xd, Sheets("Sheet2").Range("a2:a800"), 0)


xd has a value of "2010-01-11" after the substitute function has 
executed and column a in Sheet2 has date values with exactly the same 
format. I always get "Error 2042" no matter what I do. Vlookup gives the 
same result.

It has something to do with dates, I'm sure.

Can someone help?

TIA, Pierre.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads