You are here: PSPad forum > English discussion forum > Re: Macro Error

Re: Macro Error

#1 Macro Error

Posted by: maki | Date: 2019-06-23 06:47 | IP: IP Logged

Macro Error

Message:

Nieprawidłowy znak

Line: 4

option explicit

Options: Reply | Quote | Up ^


#2 Re: Macro Error

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.

Options: Reply | Quote | Up ^


#3 Re: Macro Error

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.

Options: Reply | Quote | Up ^


#4 Re: Macro Error

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

Options: Reply | Quote | Up ^


#5 Re: Macro Error

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.

Options: Reply | Quote | Up ^


#6 Re: Macro Error

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

Options: Reply | Quote | Up ^






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