run time error 6

[dabrows]

morning everyone hoping you could help out. below is code for extracting the x and y parameters for a spline function. i am getting a run time error 6 at the bold line, when j=7, step=32767, nstep=630.

tips/suggestions would be incredible. please and thanks

Please Login or Register  to view this content.

[dabrows]

i changed the dimensions from integer to long. will give that a shot

[MaczaQ]

declare step as Long
right now you have it as integer so you can only index up to 32,767

Best Regards

[Roger Govier]

Hi

Try Dimming these as Long instead of Integer

Dim i As Integer, j As Integer, step As Integer