Ultimate Index: combine (nest) INDEX and MATCH..

categories Excel Formulas | 411 views | Tags: column, formula, index, lookup, row, variable

Excel VBA macro to print your file to PDF..

categories VBA Snippets | 1,373 views | Tags: excel, free, macro, pdf, print

Auto Run Excel VBA Macro Code when opening workbook

categories VBA Snippets | 119 views

Sort worksheets in active workbook

categories VBA Snippets | 106 views | Tags: macro, sheets, sort, within, workbook

Merge cells without losing values

categories VBA Snippets | 124 views | Tags: cells, column, data, losing, merge

Use a defined name in your macro

categories VBA Snippets | 322 views | Tags: a, defined, excel, macro, name, refer, use, vba, within

Gather User Data/Input via an InputBox

categories VBA Snippets | 265 views | Tags: data, excel, formula, input, inputbox, macro, refer, user, vba

Clear content for all unprotected cells

categories VBA Snippets | 249 views | Tags: all, cells, clear, empty, macro, not, protected, sheet, unprotected

Remove all defined names from a workbook

categories VBA Snippets | 108 views

Protect / Unprotect all worksheets in a workbook

categories VBA Snippets | 119 views
 Page 3 of 4 « 1  2  3  4 »

RSS  Entries RSS | Comments RSS

  • Categories

    • Excel Add-In
    • Excel Formulas
    • Excel Tips & Tricks
    • VBA Snippets
  • Pages

    • About
    • Excel Shortcuts
  • Favorite Links

    • Code For Excel And Outlook Blog
    • Ozgrid.com
    • Ron de Bruin