Hello,
I'm basically teaching myself VB programming as I go here. Basically I have a sheet that has information organized like this:
Column A:
MF 5-6
T
T
T
T
MF 6-7
T
T
etc...
Column B:
(Blank)
AAA
BBB
CCC
DDD
(Blank)
AAA
BBB
etc...
What I'm trying to do is concatenate the non "T" cells from column A with the non blank cells from column B so i'll have something like:
MF 5-6AAA
MF 5-6BBB
...
MF 6-7CCC
MF 6-7DDD
And so on. Currently my code goes one by one and puts them all together which takes it quite a while and this is something I run often. I was thinking maybe an array would help where I could have:
Array 1:
MF 5-6
MF 6-7
Array 2:
AAA
BBB
CCC
DDD
And somehow put them together. The number of values in each set can change. Unfortunately I'm getting stuck at the point of populating the array based on the range of cells. I've done a bit of searching and can't find out how to do this.
The reason for doing this is to setup a series of names that I can define and refer to each row for populating charts.
Any help would be greatly appreciated on how I can speed this up.
Thanks!
Bookmarks