Microsoft Excel

Ron de Bruin
Excel Automation

Microsoft MVP Program

Other Topics

VBA code

Where do I paste the code that I find on the internet

How do I create and use a PERSONAL file for my VBA code

How do I use Application.Run in Excel

Import and Export VBA code


Excel Function Bible (468 example workbooks)

Excel Function Bible


Check if Folder, File or sheet exists or file is open

Test if Folder, File or Sheet exists or File is open


Display Excel Help pages in Excel

Help Context IDs for Excel 2000-2013


Find last row or column with data or find certain values

Find last row, column or last cell

Find value in Range, Sheet or Sheets with VBA


Print tips for Excel

Printing non-contiguous areas on one page

Hide rows, columns or cells when you print a sheet

Examples to print worksheets

More tips for printing


International Excel Issues

Excel version and Office language settings

International Worksheetfunction problems

Week numbers in Excel

ISO Date Representatation and Week Numbering

Other International Excel Issues


Different examples

Change formulas to values

How do I create/use a custom or default sheet template

Cleaning "Dirty" Data