Range question needs explanation

[lillypop]

Hello

I need to 'de-code' someone else's left over codes..and have come across this line


Range(Range("Outcome"), Range("Outcome").Offset(UBound(meanoutput, 1), UBound(meanoutput, 2))) = meanoutput

I suppose that I will need to replace "Outcome" with something else, but first I will need to understand what this means. Any idea? Range(Range("Outcome"), Range("Outcome")

 

[Norie]

I think the first thing you should check for is a named range called 'Outcome'.

That's what appears to be a major part of this.

The second thing you need to look at is, what I presume is an array, meanoutput.

 

[Eric W]

meanoutput must be an array.
Outcome must be a named range on the worksheet, probably 1 cell.

UBound(meanoutput, 1) returns the number of rows in meanoutput

UBound(meanoutput, 2) returns the number of columns in meanoutput

Range("Outcome").Offset(r, c) points to the cell that is r rows down and c columns across from the upper left cell of Outcome.

Range(Cell1, Cell2) creates a range object with the upper left corner at Cell1, and the bottom right corner at Cell2.


So when you put it all together, that line puts the entire contents of meanoutput to the worksheet, starting at the upper left corner of a named range called Outcome.