Passing a variable through a variable?

**domgilberto** · 05-26-2016, 08:08 AM

How can I do something like this:

Please Login or Register  to view this content.

Any thoughts?

I basically want to call a variable "HighAsk(x)" inside for loops that references: Sheet2.Cells(x,y) so it makes for reading my code a lot easier!

**MrShorty** · 05-26-2016, 08:51 AM

I am not sure I understand what you want to do.

The error that statement gives me is "Sub or Function not defined" referring specifically to the "Highask(x)" part. That could be because you did not post the entire code and you have somehow defined what highask(x) means elsewhere. A type mismatch error suggests that highask() is defined or dimensioned in some way that is incompatible with that cell's value.

My first impression is that you want highask() to be an array, and you are trying to load that array with the values in column 3. Simply adding

Please Login or Register  to view this content.

to the code snippet above, the code runs without error and highask(9) contains whatever is in C9 of the specified sheet.

Look at how you are dimensioning or defining highask() and see if that suggests a solution.