Hi guys,

is there an easy way to sum part of a row of a two dimensional array in memory?

Situation:
1) I put 150 rows by 130 columns of the worksheet into an array in memory
2) I do webscrapes and paste the results into the array rather than the worksheet
3) I want to sum part of each row (for example, row 20, columns 24:27) and store that into column 23 of row 20 in the array

when I'm all done, I paste this back into the worksheet.

My array is called 'sht'

I tried the following, but that doesn't work.
sht(20, 23) = Application.Sum(Sht(20,24),Sht(20, 27))
What am I doing wrong here?