ERLANDSEN DATA CONSULTING Excel & VBA Tips   Informasjon på norsk / Information in Norwegian

Valid HTML 4.01 Transitional

These pages are no longer updated and are only available for archive purposes.

Click here to visit the pages with updated information.

Document: Description: Sort by date
Apply a default header/footer using Custom Views How to apply a default header/footer to a worksheet before printing 2004-06-07
Compare two worksheet ranges Compare the content of two worksheet ranges. The result is displayed in a new workbook listing all cell differences. 1999-12-20
Compare two worksheets Compare the content of two worksheets. The result is displayed in a new workbook listing all cell differences. 2005-06-09
Convert between column numbers and column references Convert a number between 1 and 256 to a column reference between A and IV, convert a column reference (A - IV) to a column number between 1 and 256. 1999-12-20
Convert negative values treated as text When you import numbers from data sources outside Excel it sometimes happens that the negative values is treated as text if they have the minus sign after the value. With this macro you can convert these negative numbers to a valid negative value Ex 1999-12-20
Copy column widths and row heights Copy column widths and row heights from one range to another. 1999-12-20
Copy worksheet information to Word Copy information from a worksheet to a Word document. 1999-12-20
Delete rows and columns Delete all empty rows or columns within a worksheet range. You can also delete every n-th row or column. 1999-12-20
Delete sheets without confirmation prompts Delete sheets from a workbook without the user being prompted for any confirmations. 1999-12-20
Determine if a cell is within a range This function can determine if a cell is within a specific range. 1999-12-20
Determine if a sheet exists in a workbook Check if a sheet exists in a workbook. 1999-12-20
Insert pictures How to insert pictures at specific locations in a worksheet. 2000-04-15
List, change or delete external formula references (links) List, change or delete external formula references (links) in cells that refers to other workbooks. 2002-05-20
Return how many characters that will fit in the column width This function returns how many characters that will fit inside a column when you are not using the normal font. 2006-01-27
Row and column background color Example macros that can be used to color rows and columns. Conditional formatting of rows and columns. 2002-07-17
Set row height and column width in millimeters You can use these macros to set the row heights and column widths in millimeters instead of using points and average character count. 1999-12-20
Erlandsen Data Consulting     http://www.erlandsendata.no/   
Excel & VBA Tips   Copyright ©1999-2017    Ole P. Erlandsen   All rights reserved
E-mail Contact Address