using the split function on an array of strings

**jordan2322** · 01-30-2013, 08:47 PM

Hello everyone.

I have an array thats elements are populated with strings of the ranges in the format of
Reference_Array(i,j,k) = "myWorkbook,ThisWorksheet,B3:B10"

how do i split this array element, deliminated by the commas?

Please Login or Register  to view this content.

Thanks for your help
Regards Jordan

**protonLeah** · 01-30-2013, 09:02 PM

Post the code for BuildReferenceArray. You imply that it builds an array with strings like: "Worksbooks(myWorkbook).Sheets(ThisWorksheet).Range("B3:B10")"
But that would result in only a one dimensional list (vector). Where do three dimensions fit in?

**jordan2322** · 01-30-2013, 09:07 PM

Heres the code for the BuildReferenceArray. the array is 3 dimensional and holds various information from the worksheet in which its run.

yes your right - the BuildReferenceArray fills its elements with strings like
Workbooks(ThisWorkbook).Sheets(ThisSheet).Range(A1:A10)

The other dimension holds more range strings like the one i've written above. and another dimension is used for the number of worksheets in the workbook.

Please Login or Register  to view this content.

**jordan2322** · 01-30-2013, 11:41 PM

I've modified the title of this thread to better reflect what i'm after..
I've also modified the BuildReferenceArray - where I'm adding strings to the array elements for B column through to the H column
I'm now adding strings of the form MyWorkbook.xls,01-01-2013,A1:A10

So now i have array elements of string type which i wish to split into the 3 individual components (deliminated by the comma) so that i can use them in functions such as
workbook(MyWorkbook.xls).Sheets(01-01-2013).Range(A1:A10).Interior.ColorIndex = 3

if someone could point me in the right direction with how to do this that would be much appreciated!

**nilem** · 01-31-2013, 12:52 AM

Hi Jordan2322
maybe something like this

Please Login or Register  to view this content.

using the split function on an array of strings

LinkBack

Thread Tools

Rate This Thread

Display

using the split function on an array of strings

Re: treating an element from array as string

Re: treating an element from array as string

Re: using the split function on an array of strings

Re: using the split function on an array of strings

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions