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

[almouchie]

You company's IT Help Desk has your number on Speed Dial

i like that a lot
at my work they call me the formula wizard & I am no more than a little above average
its when i log on here that i am amazed & eager to learn & know more

it starting to get me more interested in learning VBA & macro

can any1 recommend the best VBA books for beginner & intermeidate & advanced level

a big thanks to every1 who help on this forum & those who answer us the beginners

 

[Smitty]

First would be VBA & Macros for Excel by Mr Excel (aka Bill Jelen.

My favorite is EXCEL 2003 POWER PROGRAMMING WITH VBA by John Walkenbach.

Hope that helps,

Smitty

 

[gingerafro]

You hate it when someone uses the phrase "...and/or..." in a sentence and you have to point out that you only need to use 'or'.

 

[ktab]

Your special order handmade bass guitar has: x as string, z as string, y as string, w as string (and of course strip as LONG cause you know your great and it has to fit you somehow, right?)
It's a bass guitar cause you know you're the bas(i)s at work so your collegues can rock 'n roll

 

[Felix Atagong]

The day Ikea sells a Pivøt Table, you'll immediately buy one.

 

[erik.van.geit]

when you define a kilometer as 65536 rows of 0,6 inch

 

[whiteghost]

Felix can you provide a schemeatic of Ikea's pivot table?

 

[Felix Atagong]

Felix can you provide a schemeatic of Ikea's pivot table?

Sorry, I don't speak Swedish and those plans are still top secret! But apparently it is like a Rubik cube with removable feet.

 

[Excel Hopeful]

When you find this tread and understand most of it.

When some new guy starts at your job and calls himself and Excel expert because he know how to use the Macro Record button.

When all you want to do is work in VBA.

When your boss who doesn't think much of you, is completely amazed by work he never knew you could do.

When you think:

Your son 2+2=;(you, smiling)=2+2

&

You create vba for 30 minutes when you could have done it manually by hand for 10 seconds.

Is extremly funny.

 

[Jackblack1]

You know your a guru....

You know your a guru....

1) When your replies to every is you should alway Excel.
2) When on tuesdays you mistakenly call it macroni night.
3) When everyones looking at you weird and your looking at them weird.
4) when your code functions better than you function!