Using Worksheet Functions with VBA

Many useful worksheet functions do not have a VBA equivalent. To use them, use the syntax 

I n t Returns the integer part of a number (rounds down). 

LBound Returns the lower limit of an array dimension. 

LCase Converts a string into lowercase letters. 

M i d Returns a specified number of characters from a string. 

Application.Find find text,within text,start num) 

Returns the integer part of a number (truncates). Returns the integer part of a number (rounds down). Returns True if the variable is an array. 

Returns True if the expression is null (i.e., contains no valid data). 

Returns the length (number of characters) in a string. Returns the natural (base-e) logarithm of a number. Returns a specified number of characters from a string. Returns the rightmost characters of a string. 

---