Array to worksheet range

I'm stumped with a small block of code which writes an array to a worksheet range. The array contains 172 rows of 2 columns consisting of dates and values. The resized range contains 172 rows of 2 columns.

The result of execution is that row 1 of the worksheet is empty, column A of the worksheet is empty, column B of the range worksheet contains the array dates, the array values column is lost, and the 172nd row in the array is lost. It looks like the output is being offset by 1 row and 1 column which puzzles me.

This is a summary of the code and the results displayed in the Intermediate window. I've been kicking on this for two days and need another set of eyes. Thank you.

Earl Adamy

1) displays Worksheet name
2) varrDivHistoryWithFuture - displays size and first last contents
3) rQSDivHistory (worksheet range) - displays size and first last contents
4) clears the worksheet
5) rQSDivHistory - resizes range to size of array
6) sets rQSDivHistory.value = varrDivHistoryWithFuture
7) rQSDivHistory - displays size and first last contents

Please Login or Register  to view this content.

I believe that I included all of the relevant code in my question; however this is the entire sub for anyone willing to wade through it. Earl

Please Login or Register  to view this content.

When I read your note, my first reaction was that it couldn't be because I use Option Base 1 in all of my modules. However it was easy enough to add the lower bound to the debug.print statements which proved you are correct:

Please Login or Register  to view this content.

It is interesting that I had verified UBound without verifying LBound due to the strength of my assumption regarding Option Base 1. Failing to explicitly specify the lower bound in Redim statements has been a long time bad habit used in some huge projects with hundreds of dynamic arrays. Amazingly, this is the first time this has bitten.

I thank you for great job with "another set of eyes"!

Earl Adamy