Interesting things about LONGS that I have just found out...

[Wokawidget]

OK, if we have:

Dim lngWoof As Long
   lngWoof = lngWoof +1
   Debug.Print lngWoof
   lngWoof = lngWoof + 15
   Debug.Print lngWoof

Now, the 1st thing to be "printe" in the immediate window will be the number 1, and the 2nd thing to be printed will be 16...
Now, if we follow on from the above code and add...

'Above code +
   lngWoof = lngWoof & 1
   Debug.Print lngWoof
   lngWoof = lngWoof & 15
   Debug.Print lngWoof

Now, instead off adding 1, the & statement multiples it by 10 and then adds one. The & 15 cause it to get multiplied by 100 then adds 15

So & n, would be like: [where n is ANY number]

lngWoof = (lngWoof * 10^(Len(CStr(n)))) + n

I just found that interesting...HOW SAD!

Woka

[plenderj]

Probably some binary arithmetic thing ?

[Lightning]

This is, I think, because "&" is a string operator, so both parts (before and after the & -sign) are converted to string, the &-operation takes place (The second value is put after the first) and then it is converted back to long. But I can be wrong

[Wokawidget]

Originally posted by Lightning
This is, I think, because "&" is a string operator, so both parts (before and after the & -sign) are converted to string, the &-operation takes place (The second value is put after the first) and then it is converted back to long. But I can be wrong

Think u hit the nail on the head there. Seems like a very reasonable explanation

Woka

[beachbum]

lol u knob!!

[Wokawidget]

Doh!

Look, it's 1st thing on a Friday morning, the coffee ain't kicked in yet, and the weeknd is looming, my mind is elsewhere

Woka

[KayJay]

Originally posted by Wokawidget
OK, if we have:

Dim lngWoof As Long
   lngWoof = lngWoof +1
   Debug.Print lngWoof
   lngWoof = lngWoof + 15
   Debug.Print lngWoof

Now, the 1st thing to be "printe" in the immediate window will be the number 1, and the 2nd thing to be printed will be 16...
Now, if we follow on from the above code and add...

'Above code +
   lngWoof = lngWoof & 1
   Debug.Print lngWoof
   lngWoof = lngWoof & 15
   Debug.Print lngWoof

Now, instead off adding 1, the & statement multiples it by 10 and then adds one. The & 15 cause it to get multiplied by 100 then adds 15

So & n, would be like: [where n is ANY number]

lngWoof = (lngWoof * 10^(Len(CStr(n)))) + n

I just found that interesting...HOW SAD!

Woka

Private Sub Command1_Click()
Dim x As Long
'prints 0 -> default value
Debug.Print x
 
x = x + 1
'prints 1 -> 0 + 1
Debug.Print x
 
x = x + 123
'prints 124 -> 1 + 123
Debug.Print x
 
x = x & 1
'prints 1241 -> 124 concantanated with "1"; No addition at all
Debug.Print x
 
x = x & 15
'prints 124115 -> 1241 concantanated with "15"; No addition at all
Debug.Print x
 
x = x + 5
'prints 124120 -> 124115 + 5; addition
Debug.Print x
 
End Sub

where did you get lngWoof = (lngWoof * 10^(Len(CStr(n)))) + n from?

[Wokawidget]

Because:

lngWoof = (lngWoof * 10^(Len(CStr(n)))) + n
MsgBox lngWoof

produces EXACTALLY the same answer as:

lngWoof = lngWoof & n
MsgBox lngWoof

Woka

PS Try it if you don't believe me

[KayJay]

I actually did after U my post. Guess Ur right. Neither had the time nor the inclination look for such a basic arithmetical derivation.

[MerrionComputin]

Implicit type conversion = very bad...which is why I routinely cover anybody using variants in my company in a mixture of fish heads and red ants. It's the only way to make the lesson stick

[Wokawidget]

I agree

Only I would use mini lobster instead of ants

Woka

PS I came across it accidentally as I wants to use a + but for some strange reason I typed a & and tried to figure out why my answers where so large. the actual equation is VERY basic and took all of 0.5 seconds to work out...I did not sit here pondering trying to do it

[plenderj]

Originally posted by Wokawidget
the actual equation is VERY basic and took all of 0.5 seconds to work out...I did not sit here pondering trying to do it

*cough*bull*****cough*

[Frans C]

Try this:
Debug.Print TypeName(lngWoof & 1)

[Wokawidget]

Originally posted by plenderj
*cough*bull*****cough*

Seriously...u canm't say that the equation was difficult to deduct....!
Mind you, I have done Maths all my life and concider myself an expert-ish
maybe it comes more naturally to some than others...

BUT I DID NOT SIT HERE WORKING THE ****ING THING OUT!!!

ALL RIGHT!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Hmph!...carrot munching hippies, the lot of ya!

Woka

[plenderj]

Originally posted by Wokawidget
Hmph!...carrot munching hippies, the lot of ya!

Yeah? Well at least we admit it!

[Wokawidget]

Fair enough...I lose



Woka