Hi all

Been trying to optimize this loop to run faster im exporting at list 20 000 records and it goes on forever... any tios

Code:
Sub ExportGridToExcel()

        On Error GoTo ErrorHandler

        Dim lngColCntr As Integer
        Dim strPassedString As String
        Dim lngTmpVar As Integer
        Dim intPrevRow As Integer
        Erase arrExport
...