How to adress columns

Hello

I have a little problem: I measurement data that are exactly 100 lines long but are split up in columns. Each column represents a time frame of 100ms. Thus, if you measure for 30s you get 300 columns... Now, I want to have all the data in one column. Tried to write a little macro that copies all the columns into the first one, but unfortunately that is not so easy. The columns are addressed by actual characters (A,B,C,D..) not by numbers. My program successfully gets the maximum amount of columns by fails by addressing an individual one because in they program works with numbers instead of characters (1,2,3 instead of A,B,C). Does anyone know how I can address the columns? If I am not clear enough please let me know

Thanks

Adrian

Hello Adrian,

To really answer your question quickly, you should post your workbook for review. There could issues with workbook settings as well as the coding. Please remove any confidential information from your workbook and then zip it. The maximum file size after zipping a file is 100 kb.

Sincerely,
Leith Ross