How to declare variable as Excel constant?
 

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

How to declare variable as Excel constant?
 

Hi
use
const csSortorder = value

--
Regards
Frank Kabel
Frankfurt, Germany


John Wirt wrote:
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

How to declare variable as Excel constant?
 

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)

"John Wirt" wrote in message
...
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