Right-click context menu of worksheet cell: Insert Variables...
Open the Insert Variables dialog
X-Function not designed for Auto GetN Dialog.
1. insertVar cell:=[Book1]Sheet1!col(A);
Please refer to the page for additional option switches when accessing the x-function from script
After the importing is done, there are some metadata that are saved in the Workbook Organizer and column property's user tree tab. Also, you can add variables in the user trees in the Workbook Organizer. With this X-Function, the metadata and user-created variables can be inserted into a specify worksheet cell.
You can insert multiple variables at a time. If n variables are inserted, the destination cell will be used to hold the first variable. Then the cells below it will be used to show the 2nd to the nth variables.
Please see the details about the Insert Variables dialog, in the this user guide page.
insertArrow, insertGraph, insertImg, insertNotes, insertSparklines