VBA Excel Error 2029

[johnnymagee]

I have a spreadsheet with dates in Column A, unit names along the top and a whole lot of vlookups on the eomonth of the dates in between. For some reason when I use VBA to read this matrix into a database, it returns "Error 2029" as the value for each vlookup.
I have a simple workaround to replace the eomonth for this but it seems odd. Anyone know why it happens?

 

[GlennUK]

And the code you use to read the matrix? How about posting that please.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[SkipVought]

I'd bet, it I were a betting man, that you are having an issue with DATES.

Why do Dates and Times seem to be so much trouble? faq68-5827


Skip,

_{[red]Be Advised![/red]
A wee deranged psychic may be runnin' around out there!
SMALL MEDUIM @ LARGE}

 

[johnnymagee]

well the code is very boring,. In effect:

for lCol = 2 to lNumCols
sUnit = sht.cells(1,lCol)
for lRow = 2 to lNumRow
dDay = sht.ceslls(lRow,1)
debug.print sht.cells(lrow,lcol)
next
next

sUnit and dDay return correct values but the vlookup in
sht.cells(lrow,lcol) returns "Error 2029", but its fine in the spreadsheet