Excel users often find themselves performing certain tasks on a repetitive basis, such as preparing reports on a weekly or monthly basis. Such tasks can involve repeated actions such as copying data from one particular source, or formatting them in a particular style, or applying … [Read more...] about How to Create Excel Macros Using Macro Recorder
excel macros
How to Extract Comments in an Excel Sheet
Comment boxes are great when you want to share additional information about Excel data. You can view all comments on a worksheet or just specific comments you want to see. However, there may be times when you need to consolidate the comments in an Excel worksheet. … [Read more...] about How to Extract Comments in an Excel Sheet
How to Unprotect Multiple Worksheets in One Go Using Excel Macro
Extract URLs From Hyperlinked Text Using Macros in Excel 2010
There may be instances when long hyperlinked text has been made pretty by cloaking it with other text. While that may serve some purposes, there may be times when you want to view the URL's that are behind the hyperlinks. If you ever find yourself in such a situation, you can … [Read more...] about Extract URLs From Hyperlinked Text Using Macros in Excel 2010