What's the "#" in VBA dimensions?

G

Gregg

I'm seeing the "#" in my recorded macros when working with dimensions.
It seems to mean "even" or no decimals. Is that correct? Just curious.
Thanks.
 
S

Shyam Pillai

It's actually the type declaration for value.

# denotes Double floating point value
?Typename(1#)
Double

! denotes Single floating point value
?Typename(1!)
Single

?Typename(1)
Integer
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What’s the best way to automatically update dimensions on a drawing image imported from a jpg to Exc 1
Select Text to End of Footnote 9
VBA word change keys 0
Shapes Changing but remaining same dimensions! 0
Drop down list control value in vba 2
Yikes! Don't understand PPT 2007 rotated shape dimensions 1
How to insert .wmv files at the correct dimensions in PowerPoint20 1
Using project as a resource tracker 0

Top