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