If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Array sub-script within an an arry element

Thread starter KG Old Wolf
Start date Oct 14, 2009
Tags

arrays element index sub-scripting an element

KG Old Wolf

Board Regular

Oct 14, 2009

I have the Bill Jelen book "VBA and MACROS" but I am missing something pretty basic.

I want to load a string to an array element and then examine a character or set of characters within it. For instance, I want to load "Ph: (212) 555-1212" and examine if the first three characters = "Ph:" or if the fifth character = "(".

I have been able to do this in other languages (sub-scripting an array element) but I am missing something here. I have loaded the string to an "Array as Variant" and then reDim Array (1 to 18) and then attempted to access "Array (1,2,3)" but that doesn't work.

I can accomplish this using other VBA commands but I want to leverage the power of array processing. What am I missing?

Thanks,
KG~