The below subroutine will take a given column letter reference and convert it into its corresponding numerical value. In this article, I'm going to show you how to easily convert a cell column numerical reference into an alphanumeric (letter) reference and vice versa. The VBA Split function allows you to separate out the component parts from within a standard text string where each component uses a specific delimiter character e.g. Creating a New Function to Allow Splitting from a Given Point.
Construction contracts act payment claim notice