By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step 259 - Type fiilter_Fields row as Long column as Long End Type

The type statement isn't that popular but can be used to pass a structure around

Type name
  var as type
  var2 as type
  var3 as type
End Type

The you declare the type by

Dim  xyz as Name

xyz.var = "123"