tominga
08-18-2005, 06:58 AM
Help....I'm fairly good at vba but I have come across a request from a co-worker for some help and I can't figure it out.
What I need to do is loop across the columns in a given range and read information into an array.
IE I need to read the value in A1, then B1, then C1... then A2, B2, C2....
I can't figure out how to get the loop to increment by "A,B,C" ect across columns. Incrementing the row portion of the address is easy but I hope someone can help figure out how to make vba "count" across columns since they are not numerical.
Thank you,
Tom
What I need to do is loop across the columns in a given range and read information into an array.
IE I need to read the value in A1, then B1, then C1... then A2, B2, C2....
I can't figure out how to get the loop to increment by "A,B,C" ect across columns. Incrementing the row portion of the address is easy but I hope someone can help figure out how to make vba "count" across columns since they are not numerical.
Thank you,
Tom