You are here: PSPad forum > English discussion forum > Macro Error
Posted by: maki | Date: 2019-06-23 06:47 | IP: IP Logged
Macro Error
Message:
Nieprawidłowy znak
Line: 4
option explicit
Posted by: pspad | Date: 2019-06-23 07:14 | IP: IP Logged
Last warning.
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
Seriously?
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?
sub descending()
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
Next i
end sub
Posted by: pspad | Date: 2019-06-23 12:59 | IP: IP Logged
Quote:Macro Error
Message:
Nieprawidłowy znak
Line: 4
option explicit
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
Editor PSPad - freeware editor, © 2001 - 2024 Jan Fiala, Hosted by Webhosting TOJEONO.CZ, design by WebDesign PAY & SOFT, code Petr Dvořák, Privacy policy and GDPR