I'm trying to declare an array with a size which varies depending on the number of columns in use (I'm building a check into the workbook open).
When I use :
Static nColorIndices(1 To cnNUMCOLS) it returns "constant expression required" whenever cnNUMCOLS is a variable. This variable will only change when you open the workbook though.
Any ideas of a way around this?
Hello labogola,
Here is an example of passing in the variable to set the array's size.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Leith,
I'm still having some issues with it.
There is a public variable declared in a module.
Upon startup these variables are both defined by another script which counts rows and columns. I have tested it, and the output is fine.Please Login or Register to view this content.
However, when I run this script below it starts spitting out subscript out of range errors and the public variables are no longer defined as they were.
I don't get why that changes the public variables as I'm not asking it to change anything.Please Login or Register to view this content.
Last edited by labogola; 01-08-2012 at 10:42 PM.
Hello labogola,
The Public variables should not change because of a run-time error. I think it best if you post your workbook for review.
If you have unhandled errors, it tends to cause state loss and your variables will get reset to their default values.
Good luck.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks