Reply to thread

Message: [QUOTE="Peter T, post: 6458285"] It's still working fine for me, at least with your original test data. The error suggests the value hIn is either 0 or above the ubound of the array. Add these debugs after the original code lines as indicated h = (dLast - dFirst) * 24 Debug.Print "h: "; h hIn = Int(hIn) Debug.Print i, "hIn: "; hIn I get the following in the Immediate window (ctrl-g) with your data h: 53 1 hIn: 2 2 hIn: 3 3 hIn: 4 4 hIn: 33 5 hIn: 48 Post your results Regards, Peter T [/QUOTE]