It doesn't matter, but declaring as Long is the most efficient. Integers
could cause a problem if you try and load a too large value in them. Long is
safe and fully typed.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"RB Smissaert" wrote in message
...
For a VB6 ActiveX dll I had to declare some xl Constants.
Does it matter which of the following 3 ways you choose?

Const xlUp as long = -4162
Const xlUp as Integer = -4162
Const xlUp = -4162

It looks the datatype is Integer but I am not sure.

RBS