Although it is best to always declare the data type on a Dim statement,the data type is optional.

Name: Although it is best to always declare the data type on a Dim statement,the data type is optional.
Brand: Quizplus
Rating: 4.8 (31 reviews)

Question

Quizplus · Accepted Answer

While it is best practice to always declare the data type on a Dim statement, it is not required and the data type is optional. If the data type is not specified, VBA will try to determine the data type based on the initial value assigned to the variable.

Although It Is Best to Always Declare the Data Type