Forum Discussion

robert_L's avatar
robert_L
Occasional Contributor
12 years ago

how to get the max number of columns used/populated in spreadsheet (and not the excel max column limit)?

Hello, I'm using the ExcelCompare Script Extension that is referenced in the Compare Excel Files article (http://support.smartbear.com/viewarticle/9046/). In it, there is a function ...
  • paul_scroce's avatar
    12 years ago
    Yes you could use oSheet.UsedRange.Columns.Count