VBA: Output Headers from Array to Sheet Range

[zero269]

Hello,

I'm trying to figure out the best approach to output the header values from my array to the worksheet. Currently I'm using this manual method:

'Declarations
Dim FirstCol As String: FirstCol = arrSettings(LBound(arrSettings), 7)
Dim LastCol As String: LastCol = arrSettings(UBound(arrSettings), 7)

'Headers
With wsLogs.Range(FirstCol & "2:" & LastCol & "2") 'wsLogs CodeName
    .Font.Bold = True
    .Value = Array("Quiz", "Title", "Page", "Book", "Level", "Words", "Status", "List", "Media")
End With

However, all of these values are stored in my array in their #1 slot such as arrSettings(1,1)

I'm confident I could ultimately output one value and then offset by a column, but I would like to be able to reproduce the above if possible using the values stored in the arrSettings array.

Thank you. Any help would be greatly appreciated...

 

[Peter_SSs]

Seems like an awkward way to store the information & I don't have all the array values to test, but try this

.Value = Array("Quiz", "Title", "Page", "Book", "Level", "Words", "Status", "List", "Media")
.Value = Application.Transpose(Application.Index(arrSettings, 0, 1))

 

[zero269]

Seems like an awkward way to store the information & I don't have all the array values to test, but try this

.Value = Array("Quiz", "Title", "Page", "Book", "Level", "Words", "Status", "List", "Media")
.Value = Application.Transpose(Application.Index(arrSettings, 0, 1))

Thanks Peter!

That did the trick! I knew there was a better way than me trying to loop and offset.

At first I wasn't sure how this was going to work, but now that I was able to see what you were doing as it relates to a Formula in the sheet... I tested it out there too, and can see what you did more clearly now. This was very helpful.

Now I can use this to work with the other data in the array by first testing it with the Table data.

The data in the array are settings for formatting reports/logs to ensure consistency. It's also my test bed for working with arrays... so far so good with your help and several others here.

 

[Peter_SSs]

You're welcome.