RItesh, I think you are very new to excel.. Press ALT + T M R to start Recording A Dialogue Box will open and Ask For Macro Name and ShortCut Key what you want to assign for that with the location where you want to store that Macro.. If you select Personal Macro Workbook .. that macro will be available for Whole Excel Application.. after Click Ok Your Macro Recording will be Start .. and Again Press to Stop Recording . In Between this Duration all work what you will do on Excel Sheet will be Recorded as a Code , if you want to See that codes Prest ALT+F11 and Go to Module, You will see all step what you have done in the form of Codes,
I think Macro Recording is the First step to Learn VBA, You will See many Object ,Property and Method , How they works and when you will learn how VBA works.. you will be able to manipulate the Object of Excel, Happy Learning.. Rajan. -----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ritesh Jain Sent: Saturday, June 04, 2011 1:27 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ How to record a macro Dear Friends, Can somebody please guide me on how to record macros in excel? Regards, Ritesh Jain -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
