X-Function BuilderX-Functions are created with X-Function Builder. You can open X-Function Builder by choosing X-Function Builder on the Tools menu or by pressing F10.
The X-Function Builder dialog is shown below.
The steps below will walk you through the creation of an X-Function that will perform the task of copying data from one column to another column.
ocol = icol;
Now that we have successfully created our X-Function, we can test it.
After the X-Function executes, the worksheet will contain a third column which will contain a copy of the data from column A.