Recording Macros in Excel to Make Tasks Easier


Gary Schwartz's Blog

Excel is a great program and it is even better when you get it to do repetitive or complex tasks at a click of a button. You’ve thinking but how is that possible when everyone has different requirements and tasks to do. That is where recording macros comes in handy. You basically get it to remember everything you do and then you can simply play it back when you need it. It creates the script or code for you, this code is called Visual Basic for Applications (VBA).

So there are many things you can do including setting up a spreadsheet, formatting it and then automatically printing it out, or perhaps you want to import some data, reorganise the information, format it, save it and then print it. These are just a couple of examples of where you can use this record macro facility. It is a nice feeling to…

View original post 113 more words