Déli Délo

Accueil > Computer related > VB Functions - for Excel

VB Functions - for Excel

Useful functions free to copy, use and reuse

samedi 4 janvier 2003, par DlyNouille

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