studying VBA

Advanced modelling in finance using Excel and VBA - Jackson and Staunton

It's a pretty decent place to get started.

What is it that you think VBA will give you 'tons of advantage' in?

after working in IBD, i mean to agree VBA is useful.

Maybe not 'tons of advantage' but I hope it would help me to get into IBD. :)

btw, thanks for the recommendation!

After working in IBD and knowing VBA, I'll tell you that it is not useful on the job, and it is certainly not going to get you INTO IBD. Nobody will even ask about that skill. You really think somebody will look at the section on your resume and say wow you know VBA? Can you write me a macro to make all my cells blue? HOly shit you're hired.

Please, do everyone a favour and refrain from posting mindless and dense comments. If you took a second to read his posts (mainly his second), no where did he mention that it will be his "hook". Now, if there were two candidates, ceteris paribus, they would definitely choose the candidate with VBA skills, because it DOES help, regardless of what you think.

VBA isn't going to be tremendously advantageous to the firm, but to you. You'll save a solid 2 years of your life macroing through VBA over your career, for sure.

VBA IS useful period

Uhh...NO SHIT if two candidates were EXACTLY the same except the vba then it would help. When the fuck does that happen? Never.

If you are TIED for the position, then clearly you could have done better with your time preparing for the interview, not studying VBA.

So please do everyone a favour and refrain from posting mindless and dense comments.

how long will it take to get thru the book?

Dim ms as Worksheet
For Each ms in ThisWorkbook.Worksheets
ms.range("a1","iv65535").Interior.ColorIndex = 5
Next
---------
Can I have a job now please, Mr White?