Subscript out of range

[kgakhar]

Here's the code giving me trouble ... The line in red... DateArray() subscript giving problems but can't figure it out...

Please Login or Register  to view this content.

Any advice is appreciated. Thanks

[:) Sixthsense :)]

What is the value of counter?

May the the for loop trying to assign a value to a DateArray() more than the assigned counter value

[AB33]

You can check a couple of things:

what is the value of LastCell?
Are the named range in column B? If not, you get an error on this line .Offset(i, -1).Value.
What is the value of counter?

[kgakhar]

The Value of Counter is 3 in this case and will neve rbe more than LastCell anyway. I am printing ".Offset(i, -1).Value" and that prints fine...

[kgakhar]

Solved It -- apparently you cannot use the same variable for external loop if the number of elements are different - which makes sense So I used an internal counter of sort to increment "DateArray" and then it worked fine -- something like

Please Login or Register  to view this content.

[Fotis1991]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED",as per our Forum Rule #9. I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.