Create Number Sequence with VBA Custom Function

An Excel custom function that allows sequental number sequences to be created.

Read More

Split Text in Excel VBA

Excel VBA offers a customised way to split out text within a cell.  Larger systems don't always talk to Excel as we would like and it is sometimes necessary to split the contents of a cell into many parts.  

Split (string, delimiter, limit, compare)

  • String - the string you wish to split or separate.

  • Delimiter - the character which divides the string into segments

  • Limit - The default for limit is -1 which means every delimite...

Read More
Tags , , ,