| 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 |
| Determine if a cell is within a range | This function can determine if a cell is within a specific range. | 1999-12-20 |
| 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 |
| Delete sheets without confirmation prompts | Delete sheets from a workbook without the user being prompted for any confirmations. | 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 |
| Copy worksheet information to Word | Copy information from a worksheet to a Word document. | 1999-12-20 |
| Copy column widths and row heights | Copy column widths and row heights from one range to another. | 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 |
| 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 |
| 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 |
| Determine if a sheet exists in a workbook | Check if a sheet exists in a workbook. | 1999-12-20 |
|
Erlandsen Data Consulting
http://www.erlandsendata.no/
Excel & VBA Tips Copyright ©1999-2024 Ole P. Erlandsen All rights reserved 
|