Cameron wrote:
I've inherited an excel file that links to data in access. It's got a
macro that runs and it says there's a type mismatch on this command:

MinDate = .Cells(3, 1).Value


Looks like the macro is running before the data has arrived.

Maybe something like this

Do While WorksheetFunction.ISNA(.Cells(3,1).Value)
DoEvents
Loop
MinDate = .Cells(3, 1).Value

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup