Other Topics

Important message to visitors of this page

Ron de Bruin decided to remove all Windows Excel content from his website for personal reasons. If you want to know why, head over to rondebruin.nl.

Luckily, Ron was kind enough to allow me to publish all of his Excel content here.

Most of these pages are slightly outdated and may contain links that don 't work. Please inform me if you find such an error and I'll try to fix it.

Kind regards

Jan Karel Pieterse

---

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

 

Copyright © 2022 Ron de Bruin

Site designed by Spider Web Woman Designs