Get Started

Hi there its me again,
I will now tell you how to start with the basic commands to create macros.

Step 1 : open an empty worksheet.
step 2: press "Alt+F11" or (Tools-->Macro --> visual basic editor)
step 3: In the VB editor select Insert--> Module
step 4: this is your interface where we can start writing codes (known as a macro).
step 5: the macro should have " Sub () " in the beginning and "End Sub" in the end.
this is how a basic structure of macro is created.
to run the macro you eith press "F5" or "Run" Button on the editor.

In next Tip I will talk about creating a small button on the spreadsheet itself and asscoiate it with the written macro.

Hey People

Hi Guys,
This is Himanshu Kashiwar. I am an Engineering Managment grad student in Syracuse University,NY. I am in my second year now.

During my summer internship with JP Morgan Chase I started developing some macros to help in process automation.I found this world very fascinating and thought I would share whatever I know about it with the world.

I will share small small code snippets and help examples in order for people to use them as guidence. Also, if you have any questions please do share it with me @ kashiwar.h@gmail.com I would try to solve it and share it with others on this blog itself.

I hope this excercise is benificial to all of us.

Thanks,
Himanshu