Syntax for setting an array item to the value of a cell

[pbgexcel]

Good afternoon all,

I'm having some trouble setting an array item to the value of cell. How can this be done?

Currently I'm working with this:

Dim ArrayName() As Variant
ArrayName(row no., column no.) = Range(column letter & row number).Offset(0, -1).Value ' I want the value of the cell directly behind the cell in question

Any and all help greatly appreciated! Please let me know if I can clarify in any way.

Thanks so much!


EDIT: I should mention that row nos. and column letters are correct in my code, I've just represented them in the code above.

 

[JoeMo]

Still can't see all the variables being initialized. For example, is Hourly a worksheet or a range or ...? What is GlobalStartingPoint?

I'd recommend stepping through the code using the F8 key to see what values the various variables take on. For example is SlidingStartingPointAsRange a valid range or is it Nothing?