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
Add path- and filenames Display the filename and path in a workbook in a cell by using a built-in worksheet function. 2000-02-04
Create Roman numbers Create Roman numbers with the built-in worksheet function. 2000-02-04
Return error values from user defined functions Make your user defined functions return error values just like the built in functions in Excel do. 2000-02-04
Return random numbers General information on how to return random numbers. 2003-03-18
Split a string and return any individual part This function can be useful when you need to return indivual parts of a string, e.g. first or last names 2005-08-06
Square root and cube root How to find the square root or the cube root of a value. 2000-02-04
Use text and numbers in the same cell By using text and numbers from several different cells in the same cell you will be able to present your worksheet results in a nice way. 2000-02-04
Use the logical functions General information about the use of the logical worksheet functions in Excel. 2000-02-04
Userdefined functions from other workbooks How to use userdefined worksheet functions from other workbooks. 2002-07-17
Worksheet functions in VBA macros Almost all of the built-in worksheet functions can be used in VBA macros. 2003-04-27
Erlandsen Data Consulting   
Excel & VBA Tips   Copyright ©1999-2024    Ole P. Erlandsen   All rights reserved
E-mail Contact Address