OverheadSheetInfo.LastVisibleColumn Property
Do not confuse this last visible column with the real last column allocated in the sheet obtained by UsedRange:
sheet.UsedRange.ColumnCount -1
.
The function returns the last column that was displayed when implementing columns. Other columns that are to the right of that column are hidden and used only by QDV for internal purposes.
The property is applicable only with the following worksheet types:
NativeSheetType.Currencies,
NativeSheetType.Material_Set_Of_Field,
NativeSheetType.Workforce_Set_Of_Field,
NativeSheetType.Families,
NativeSheetType.Manufacturers,
NativeSheetType.Suppliers,
NativeSheetType.Custom_Columns,
NativeSheetType.User_Defined_Fields,
NativeSheetType.Planner,
NativeSheetType.List_Box,
NativeSheetType.Material_Time_Frame,
NativeSheetType.Workforce_Time_Frame