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

[Smitty]

or maybe not.....

Like CBrine says: "A cheap shot is a terrible thing to waste!"

Smitty

 

[Greg Truby]

...when you see this...<font face=Courier New>

<SPAN style="color:#00007F">Private</SPAN> <SPAN style="color:#00007F">Sub</SPAN> Worksheet_Change(<SPAN style="color:#00007F">ByVal</SPAN> Target <SPAN style="color:#00007F">As</SPAN> Range)
    <SPAN style="color:#00007F">If</SPAN> Target = 7 <SPAN style="color:#00007F">Then</SPAN> Target = 4
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN>
</FONT>
and the first thing that pops into your head is "he forgot to toggle Application.EnableEvents off and back on" instead of "oh, that would be funny".

 

[NateO]

That's what I thought.

Then there's copying and pasting multi-cell ranges (Type Mismatch error)...

How about:

... you get the 'Jerry Maguire':

I was explaining to a colleague why they don't want to use a '+' operator in an and-type conditional sum with Sumproduct. Just as I was getting warmed up, he said "Nate, please stop; you had me at *".

 

[Greg Truby]

...the 'Jerry Maguire'...

Sorta. I took tips from Walkenbach's Excel Charts book and mixed them with a couple of separate chart ideas from Jon Peltier's site, and made a humdinger of a chart (sort of a histogram + waterfall + three-charts-in-one kind of thing) which I thought did a *******jack job of explaining the data succinctly. Only to have my boss tell me he preferred the simple plain-vanilla stacked-column chart that I'd tossed together in 30 seconds as a backup. The "glass-half-full" POV would be that I did learn something new!

 

[Tazguy37]

...when you see this...<font face=Courier New>

<SPAN style="color:#00007F">Private</SPAN> <SPAN style="color:#00007F">Sub</SPAN> Worksheet_Change(<SPAN style="color:#00007F">ByVal</SPAN> Target <SPAN style="color:#00007F">As</SPAN> Range)
    <SPAN style="color:#00007F">If</SPAN> Target = 7 <SPAN style="color:#00007F">Then</SPAN> Target = 4
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN>
</FONT>
and the first thing that pops into your head is "he forgot to toggle Application.EnableEvents off and back on" instead of "oh, that would be funny".

That's the very first thing I do when I write event code . I probably should stop that; could get me into trouble.

 

[tactps]

...when you see this...

Private Sub Worksheet_Change(ByVal Target As Range)
If Target = 7 Then Target = 4
End Sub

and the first thing that pops into your head is "he forgot to toggle Application.EnableEvents off and back on" instead of "oh, that would be funny".

Oh, Greg - that's just sad :wink:

 

[Tazguy37]

When you know all the shortcut keys by heart.

In a related area: When you know all the shortcut keys for the Windows calculator. Example: "Y" is the shortcut key for x^y, which I used to calculate 2^20 (the supposed new number of rows in Excel 12). I was curious how that number rounds to 1.1 million, actually.

Anyone?

 

[Greg Truby]

I was curious how that number rounds to 1.1 million, actually.

Floating point error?

 

[NBVC]

...when you can't think of a good one because all the good ones are taken.


...when you set the Mr.Excel.com forum as your home page of your browser


....when you're fighting over who's gets to give the best answer to the OPs questions.

....when you find yourself staying up all night to answer forum questions.

...when you log out of the Mr.Excel forum only to find yourself logging right back in seconds later

....when you find yourself going back to spreadsheets you created ages ago to change the formulas according to the new things you learned in this forum and get pleasure from seeing them work so nicely.

...when your coworker says "step away from the computer" after seeing you taking a fit over a formula not working right.

 

[TheBuGz]

You know you are an Excel guru when......
a new book named TheBuGs in Ms Excel by Jazib Iqbal aka TheBuGz and Bill Jelen aka Mr Excel is in the Market