You know you are an Excel guru when ....

[Egress1]

When you write code in your sleep you MAY be an Excel Guru

When you change your method of coding from Modular to Zen

When your coworkers give up trying to understand your self mutterings

When you offer up ten different solutions to fix a single problem

When asked to build wagon you produce a Cadillac

When tasked to write a "Difficult" program an hour later you try to figure out what you're going to do with the rest of your work week.

 

[TommyGun]

When your girlfriend writes...Private Function Satisfaction(byval SweetSpot as Variant) as Long...on her body to get your attention, then you might be an Excel guru.

***Sorry, but I'm feeling a little frisky this morning***

 

[NateO]

When your girlfriend writes...Private Function Satisfaction(byval SweetSpot as Variant) as Long...on her body to get your attention, then you might be an Excel guru.

Does this make one a guru, or the girlfriend clever?

In any case, wouldn't variant be object? You might be guru if you told her it's more efficient to opt for the early bind versus the late bind.

 

[TommyGun]

No, when it comes to my experience, SweetSpot always acts as a variant! I can never find the **** thing!!! J/K

 

[Bruno_x]

When you live in the nice little village of eksel - belgium :wink:
http://www.mrexcel.com/board2/viewtopic.php?t=28169

No, in that case you're obviously an addict...

 

[just_jon]

No, when it comes to my experience, SweetSpot always acts as a variant! I can never find the **** thing!!! J/K

Well, it is the Object of your affections!

 

[Juan Pablo González]

Well, it is the Object of your affections!

But who says that an Object can't be a Variant ?

 

[NateO]

But who says that an Object can't be a Variant ?

Right, or the variant is an object?

Best to use typename and typeof:

Sub VarOuObj()
Dim y As Variant
Set y = CreateObject("WScript.Shell")
MsgBox TypeName
MsgBox TypeOf y Is Object
Set y = Nothing
End Sub

 

[Mark O'Brien]

Re: You know you are an Excel guru when .... you restructure a reply to this thread after arguing about the semantics of the joke.

 

[TommyGun]

Re: You know you are an Excel guru when .... you restructure a reply to this thread after arguing about the semantics of the joke.

I AGREE!!!