VB.NET and Excel: Determine Cell Descriptor from Array Upper Bound

When you have a large array, how can you  quickly dump it to an Excel range?   Thus far, I am using something like:

Sheet.Range("A1", "BC2000").Value = xmatrix

Open in new window


But I need to dynamically determine the "BC2000" based on the upper bounds of the array.  How can this be done?
lep1Asked:
Who is Participating?
 
NorieConnect With a Mentor VBA ExpertCommented:
I don't quite see why Resize wasn't enough.

You've used it with the dimensions of the array to get the correct range.
0
 
NorieVBA ExpertCommented:
Use Resize with the dimensions of the array to get a range that matches the size of the array.
0
 
lep1Connect With a Mentor Author Commented:
My array is xarray(,) and the following was required in order to successfully fill the range using autosizing.   Thus, resize was not enough:

            Dim oXL As Excel.Application
            oXL = CreateObject("Excel.Application")
            oXL.Visible = True
            Dim oWB As Excel.Workbook
            Dim oSheet As Excel.Worksheet

            ' Get a new workbook.
            oWB = oXL.Workbooks.Add
            oSheet = oWB.ActiveSheet
            oSheet.Name = "mytest"

            Dim Rng As Excel.Range
            Rng = oSheet.Range("A1", Reflection.Missing.Value)
            Rng = Rng.Resize(xarray.GetLength(0), xarray.GetLength(1))
            Rng.Value = xarray

Open in new window

0
 
NorieVBA ExpertCommented:
Apologies, I assumed that you just needed a pointer because you only posted one line of code which I assumed was part of a larger block of code.
0
 
lep1Author Commented:
It would be more helpful for expert to provide all code necessary for solving an issue, and not to give pointers that cause users to continue to look for solutions.  I think users are not seeking coaching, rather explicit detailed solutions.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.