| ERLANDSEN DATA CONSULTING |
Excel & VBA Tips
|
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 name |
| 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 |
| Compare two worksheets | Compare the content of two worksheets. The result is displayed in a new workbook listing all cell differences. | 2005-06-09 |
| Apply a default header/footer using Custom Views | How to apply a default header/footer to a worksheet before printing | 2004-06-07 |
| 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 |
| 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 |
| Insert pictures | How to insert pictures at specific locations in a worksheet. | 2000-04-15 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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. | 1999-12-20 |
|
Erlandsen Data Consulting
http://www.erlandsendata.no/
Excel & VBA Tips Copyright ©1999-2026 Ole P. Erlandsen All rights reserved 
|