Option Explicit Error - Variable Declaration

Hi,

When I use OptionExplicit the code doesn't work, can someone help?

Rgds
Exc4.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Also, is there a way to make "Dim ColumnArray(0 To 37, 1 To 2)" as a variable like "ColumnsInArray & ColumnsDataType"?

Solution credits to "shg":

Please Login or Register  to view this content.

Thanks.

Asked and answered elsewhere.