kweaver
Well-known Member
- Joined
- May 12, 2009
- Messages
- 2,940
- Office Version
- 365
I have an Excel workbook with a tab named "Master". I have a sorting button that calls this routine:
That sorts based on column A with the header in A10. It sorts properly.
When I save the file, close it, and reopen it, I get this error:
clicking on Yes:
Clicking to view the error:
While I'd like to view the error, I can't. However, if I just ignore this (since it won't show it to me), resave the file, close it, and reopen it...there's no error!!
(a) how do I get to view the error and (b) bypass this somehow so that the file is "fixed" [for whatever reason] and opens right away the next time I open it???
Thanks in advance.
Code:
Sub SortByEmpNo()
Sheets("Master").Activate
With ActiveSheet.Sort
.SortFields.Add Key:=Range("A10"), Order:=xlAscending
.SetRange Range("A10:G1013")
.Header = xlYes
.Apply
End With
End Sub
That sorts based on column A with the header in A10. It sorts properly.
When I save the file, close it, and reopen it, I get this error:
clicking on Yes:
Clicking to view the error:
While I'd like to view the error, I can't. However, if I just ignore this (since it won't show it to me), resave the file, close it, and reopen it...there's no error!!
(a) how do I get to view the error and (b) bypass this somehow so that the file is "fixed" [for whatever reason] and opens right away the next time I open it???
Thanks in advance.