Improve Your Excel.com
Everything you need to improve your Excel in one place!
Home Categories Tips By Email Search Contact Us Other Links Your Questions Answered

  • Assigning a Macro to a Keyboard Combination


  • Continuing Macro Lines


  • Copying Worksheets in a Macro


  • Deleting Macros from within a Macro


  • Error Using ATAN2 Function in Macro


  • Official Color Names in VBA


  • Recording a Macro


  • Retrieving Drive Statistics


  • Selecting a Range of Cells Relative to the Current Cell


  • Stepping Through a Macro with a Worksheet Visible


  • Telling which Worksheets are Selected


  • Triggering a Macro for Drop-Down List Changes


  • Understanding Macros


  • Understanding the For ... Next Structure


  • Using Macros in Protected Workbooks


  • Writing a Macro from Scratch


  • Clean Up Your Macro List


  • Convert email addresses to mailto: links


  • copy values to another workbook


  • Delete every Nth Row


  • Deploy your Excel macros from a central file


  • DOS From Macros


  • Excel -- Macro Toolbar


  • List workbook formulas to a separate sheet


  • Macro in Excel Stops After A Workbook.Open Command


  • Making a Cell's Contents Italics within a Macro


  • Merging data in multiple columns into one


  • Merging the selection into one cell


  • Path and Filename in headers and footers


  • Print different first page headers or footers


  • Protect grouped sheets


  • Recording a Macro


  • replacing a formula result with a blank space


  • Scrub a mailing list


  • XL Macro That Changes Cell Dimensions on Multiple Sheets Doesn't Run As Expected (Q213823)


  • XL Macro to Change the Date-Time Format in a Header-Footer (Q213742)


  • XL Macro to Place Filenames in Given Directory on Worksheet (Q74493)


  • XL Macro to Sort Data in Multiple Columns as One Column (Q247311)


  • XL Method to Calculate Interpolation Step Value (Q95479)


  • XL Method to Determine Whether a Year Is a Leap Year (Q214019)


  • XL Sample Macro to Import Data with More Than 256 Fields or Columns (Q272729)


  • XL2000 Macro Code to Check Whether a File Is Already Open (Q213383)


  • XL2000 Macro Example to Return Item from a Worksheet Control (Q213381)


  • XL2000 Macro Examples to Delete Duplicate Items in a List (Q240077)


  • XL2000 Macro Examples Using Option Button Controls on a UserForm (Q213549)


  • XL2000 Macro to Add a Number to a Selected Cell (Q213491)


  • XL2000 Macro to Add Labels to Points in a Bubble Chart (Q279438)


  • XL2000 Macro to Add Labels to Points in an XY (Scatter) Chart (Q213750)


  • XL2000 Macro to Append Text from One Text File to Another (Q213642)


  • XL2000 Macro to Change File Type to All Files (.) in Open Dialog Box (Q213755)


  • XL2000 Macro to Check for Page Breaks on a Worksheet (Q213831)


  • XL2000 Macro to Count the Number of Records Returned in an AutoFiltered List (Q213275)


  • XL2000 Macro to Delete Every Other Row (Q213610)


  • XL2000 Macro to Extract Data from a Chart (Q213814)


  • XL2000 Macro to Import a Text File into an Existing Worksheet (Q213816)


  • XL2000 Macro to Link a Range of Cells in Word (Q213316)


  • XL2000 Macro to Loop Through All Worksheets in a Workbook (Q213621)


  • XL2000 Macro to Open All Linked Workbooks (Q213647)


  • XL2000 Macro to Open the Most Recently Used File (Q213758)


  • XL2000 Macro to Restore Tab Split Box to Default Position (Q213505)


  • XL2000 Macro to Search for Cell Formats Font, Border, and Interior (Q213622)


  • XL2000 Macro to Shade Every Other Row in a Selection (Q213616)


  • XL2000 Macros to Loop Through Range and Act Based on Cell Value (Q213805)


  • XL2000 Macros to Return Windows and System Directory Paths (Q213496)


    • Want more tips? Subscribe to our Free Newsletter today and we will send them to you.
    Most Popular Categories |Bar_Charts |Charts |Pie_Charts |Excel Counting |Excel Filters |Pivot_Tables |Excel_Keyboard_Shortcuts |Conditional_Formating |VLookup |Games |Names_and_ranges |VBA_Examples |Macros