How to declare variable as Excel constant?

[John Wirt]

Here is another simple question.

How can I declare a variable as an Excel contant?

I've tried,

Dim csSortOrder as constant

but it doesn't work.

Thank you.

John Wir

 

[Frank Kabel]

Hi
use
const csSortorder = value

 

[Bob Phillips]

Const variable_name As variable_Type = value

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)