Accueil > Computer related > VB Functions - for Excel
VB Functions - for Excel
Useful functions free to copy, use and reuse
samedi 4 janvier 2003, par
Visual Basic Tips
Here are some usual functions that you can freely reuse.
Use ’Application.Volatile’ if the function is used in the sheet (for re-calc’
GetCurPath : Get the current path
FileExists : Detect if a file exists
SheetExists : Detect if a sheet exists
IsInRange : Detect if a value is in a specified range
CheckCreateDir : Check if a directory exists and creates one if it doesn’t