'build' a variable from within a for/next loop

Hello,

I'm writing a vba script to change, remove, cleanup and enrich records in a certain file, this file is delevered once a week.
I need to be sure that the file I use as input is always correct, otherwise my vba script will not run properly, therefore I check the columnheaders within the file.

I could solve this with with successive if statemements but I would like to tackle this a little shorter and more systematically, that way I can use this script in other files too.

I came up with the following code, the problem is that I would like to use the number in the for/next loop (k) inside another variable, so in the first loop, the variable k1 is addressed, in the second loop k1, etc. etc.

Please Login or Register  to view this content.

Is this possible at all? Please let me know.

Best Regards,

ABBOV

You cannot do it like that, but you can do it like

Please Login or Register  to view this content.

Originally Posted by Fluff13

You cannot do it like that, but you can do it like

Please Login or Register  to view this content.

Thanks Fluff13, that did it!

You're welcome & thanks for the feedback