String Length within an Array: ERROR [Excel 2010/14] (VBA Only)

[lloydgodin]

Are you allowed to limit the length of a string within an array?

I want to limit this to 2 characters:

Please Login or Register  to view this content.

I tried the following but get an "expected end of statement error"

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[tigeravatar]

lloydgodin,

I would limit it when assigning a string to a position within the array using the Left method:

Please Login or Register  to view this content.

[lloydgodin]

OK.

I just remembered that there is a different sub for the actual user input where I can limit the string length. I would not need to limit it when it is being read into the array at that point as it's already done.

What is this ERASE feature? I have not seen it before.

[lloydgodin]

OK.

I just remembered that there is a different sub for the actual user input where I can limit the string length. I would not need to limit it when it is being read into the array at that point as it's already done.

What is this ERASE feature? I have not seen it before.

[tigeravatar]

Erase is used to free up memory that has been dedicated to array storage:
http://msdn.microsoft.com/en-us/libr...=vs.80%29.aspx

[JosephP]

fyi you were pretty close

Please Login or Register  to view this content.