1

Topic: EXCEL Data type variant/integer

Hello world!
Prompt, why at a variable iColMax the data type variant/integer turned out

Sub M ()
Dim WBook As Workbook
Set WBook = Workbooks ("the Summary report on  and .xlsb")
Dim WSheet As Worksheet
Set WSheet = WBook. Worksheets ("Data")
Dim iColMax, iColMin As Integer
iColMax = 100
iColMin = 90
End Sub

2

Re: EXCEL Data type variant/integer

Because the variable iColMax is declared as variant
Read attentively the documentation on the operator Dim

3

Re: EXCEL Data type variant/integer

Shocker. Pro;
Thanks!