What is 1# in excel Macros?

Question

Does anyone know what 1# means in excel macros? I keep seeing it in macros code but do not know what it means.

For example: avg_change = 1#.

Has anyone seen this before?

score 2 · Answer 1 · answered Jun 05 '15 at 18:33

2

The type-declaration character for Double is the number sign #. Also called HASH

Some of the other type declarations are:

Integer %
Long &
Currency @
Single !
Double #
String $

answered Jun 05 '15 at 18:33

shruti1810

score 0 · Answer 2 · edited May 23 '17 at 12:06

0

It's a type declaration. The # (hash) is used to declare type Double.

edited May 23 '17 at 12:06

Community

answered Jun 05 '15 at 18:35

Bobbyrogers

2 Answers2