Hi Everybody,

I am writing a macro that uses data from a spreadsheet with over a 10K rows and around 20 columns. Its exported from Access, as in my opinion it is quicker to use data in a excel sheet as always calling a database.

Anyway to locate the right column and right row i use cells.find function. Its run a few hundred times in a second and it finds nothing even when the data are there. I am sure the code is written correctly because if I step into the macro and go line by line the cells.Find functions find every single piece of data, without problems. It seams to have problem with the count of times I need to use it.

Part of the code:

Dim Planet As Range
    Dim Datu As Range

    Datum = CStr(SQLDateFormat(Left(Datum, 10)))
    
    Set Datu = Data.Cells.Find(what:=Datum, LookIn:=xlValues)
    Set Planet = Data.Cells.Find(what:=Planeta & "    Long", LookIn:=xlValues)

   (...)

    Position = Data.Cells(Datu.Row, Planet.Column)
Anyone has experience with this? Do I need to call the Database server for each value/row/column or is there a way how to fix this?

Thank you for any help,
Best Regards,
Shuter