7 Quick and Easy VBA Macros & Tips for Excel

"Dim inty1,inty2,inty3 as Integer"

This will define only inty3 as integer. The other 2 variables will be variants.