I've tried to do this about a dozen different ways but I can't seem to get the range to set to the values I need. Any thoughts why?
Public Sub Add2Excel(varDataArray() As Variant)
Dim xlappApp As Excel.Application
'Set xlappApp = GetObject("Excel.Application")
Set xlappApp =...