I am to transfer VBA array in to active excel sheet.
There is TOTAL number of element (totalno). I get that from VBA. Now corrosponding to each number there is unique number ( noelement). I get it using VBA code.
So I learn that I can define array as
Redim noelement (totalno-1) as long.
Now I want data in excel sheet in column.
Suppose total No =10
I want “noelement” in Column A start from A1 , as shown below. Header shold be named as ELEMENT IN CELL A1
Please guide me to write VBA code.