Search results for query: *

Shall i just continue working through this methodology? Just thought there was a better way but this works.

I'm doing the basic version of what I'm trying to achieve already through this code. Here I specify the date I want to start and finish looking. Now I'm just going to look through all the days and not specify how many month symbols I am looking at. So it will either be 2 or 3. I coded it up as...

Skip thanks for the help it's appreciated. The reason I have date/time column is becuase I was using that value in a previous bit of code to line up different the values from different month symbols on the same date and time. I could have just done all of that in the code rather then output it...

this is some additional comment that I had before what I posted 'I use the j and MaxDateCount I calculated earlier and I also know that the most amount of time points any day can have is '11 becuase that is the data I have put into the data blocks in DataSimple sheet. Some will not have...

This is the part I'm having problems with. Sorry if the code is rubbish but have only just started VBA and am peicing bits together. Dim DataArra() As Variant ReDim DataArra(1 To j, 1 To MaxDateCount, 1 To 11, 0) As Variant MonthCol = 1 DateRow = 2 DateCol = 2 TimeRow...

Hi I am having some issues trying to put values into an array. I have only been coding two weeks so i'm not sure if it's the actual creation that's the issue or inputting the variables. The debugger seems to go past the defining of the array and falls over when I try and input a value for the...