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 name
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
Worksheet functions in VBA macros Almost all of the built-in worksheet functions can be used in VBA macros. 2003-04-27
Return random numbers General information on how to return random numbers. 2003-03-18
Userdefined functions from other workbooks How to use userdefined worksheet functions from other workbooks. 2002-07-17
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
Square root and cube root How to find the square root or the cube root of a value. 2000-02-04
Create Roman numbers Create Roman numbers with the built-in worksheet function. 2000-02-04
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
Use the logical functions General information about the use of the logical worksheet functions in Excel. 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
Erlandsen Data Consulting     http://www.erlandsendata.no/   
Excel & VBA Tips   Copyright ©1999-2017    Ole P. Erlandsen   All rights reserved
E-mail Contact Address