Subscript out of range if filenames are remembered
Performs a cell-by-cell comparison of Excel Worksheets.
Brought to you by:
stevetowner
If spreadsheet compare has the "remember filenames" tickbox ticket, it'll die if those files are already open in excel. If "previous session" didn't have filenames stored (or deleted from ini) but another profile has, you get same error as soon as you select that profile.
Backtracking to find version which works shows that 1.30 does not have this issue, 1.31 does.
Error happens on the last line here:
:::vbnet
Private Sub StartTiling()
If Application.Windows.Count > 1 And Not bDisableTiling Then
'Tile windows
TileWindows optAlignVertical, Workbooks.Item(cmbFileOne.Value).Name, Workbooks.Item(cmbFileTwo.Value).Name, False
Think I have the fix for it. Will be in next release.