Posted by: maki | Date: 2019-06-23 06:47 | IP: IP Logged
Posted by: pspad | Date: 2019-06-23 07:14 | IP: IP Logged
Do you really thing we are fortune tellers? Do you really think we see what is inside your head? Me not and I am really very glad I can't see it.
Try to read your topic if anybody except you can know what about it is.
Posted by: maki | Date: 2019-06-23 09:56 | IP: IP Logged
Do not know the substantive answers regarding invalid characters?
A possible problem is how your file was encoded; try to save it as ANSI and run it again.
Posted by: maki | Date: 2019-06-23 11:42 | IP: IP Logged
What's wrong here is that the script error?
max = Application.WorksheetFunction.CountA(Range("A1:A65536"))
dł = Application.WorksheetFunction.CountA(Range(Cells(1, 1), Cells(1, 80)))
For i = max To 1 Step -1
Range(Cells(i, 1), Cells(i, dł)).Select
Selection.Sort Key1:=ActiveCell, Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlLeftToRight
Posted by: pspad | Date: 2019-06-23 12:59 | IP: IP Logged
1. How can I know from this report what are you doing from this message?
2. Why do you send messages related to MS Excel and VBA into this forum? Use MS forum for your problems.
Posted by: DeborahWebb | Date: 2019-08-16 02:49 | IP: IP Logged
To set Option Explicit in the IDE
In Solution Explorer, select a project. On the Project menu, click Properties.
Click the Compile tab.
Set the value in the Option Explicit box.
When you create a new project, the Option Explicit setting on the Compile tab is set to the Option Explicit setting in the VB Defaults dialog box. To access the VB Defaults dialog box, on the Tools menu, click Options. In the Options dialog box, expand Projects and Solutions, and then click VB Defaults. The initial default setting in VB Defaults is On.
To set Option Explicit on the command line：docsbay.net