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

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

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