Remove "Option Explicit" at the top of the module

The general syntax of a variable declaration is:
Dim VariableName As DataType
If a particular variable is used without first declaring it, or if it
is declared without mentioning a
data type, as in:
Dim Age
then VBA will treat the variable as having type Variant. this is
generally a waste of memory, since variants require more memory than
most other types of
variables.

I always decler variable, then you now wich data type it is.

Regard Yngve