For macro writing in excel what is the programming knowledge I require?

I want to write macros in excel. I want to know how to start and what programming Language I should learn or is there any seperate arrangement other than exiting leading programming languages? I want to learn it in a simple way without learning any major programming langanuge. Is it possible.

For macro writing in excel what is the programming knowledge I require?
You can create basic macros by using the "Record New Macro" feature (under Tools, Macro). You can assign the macro to a shortcut key (i.e. CTRL-W). When the macro starts recording, do a few tasks (highlight, copy, paste, whatever) then choose "Stop Recording". Voila - you've made a macro.





To see the code for your macro, open up the VB editor (ALT+F11) and look double click "modules". You can then add or change a few lines of code yourself to see how it all works.
Reply:Hey,





to write macros within Excel your going to have to learn a bit of Visual Basic for Applications (VBA).





Its pretty simple once you get into it.





a link to a beginers site is located in the source list.





Hope this helps.





J