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 ...
- Yes you could use oSheet.UsedRange.Columns.Count
