Open a VBA editor in Microsoft Excel (check the steps above). Create a new module from the Insert menu. Write a custom function below. Head back to your Excel worksheet and type ...

10 ways to reference Excel workbooks and sheets using VBA ... function is useful when creating new workbooks programmatically. 10: Refer to a sheet’s code name property Code that refers to a ...