Syntax to add incrementing column letters to a string

Good morning/afternoon/evening....

Do any of you know how I would be able to add incrementing column letters to a set of strings, using VBA?

What I need is a series of paths, which end in the column letter - for example my rows need to look like this

[\\C:\mydrive\myfilename,2,A]
[\\C:\mydrive\myfilename,2,B]
[\\C:\mydrive\myfilename,2,C]
[\\C:\mydrive\myfilename,2,D]

The output has to look just like that, brackets and all, as they will serve as inputs into another system.
The "2" is the row, if that makes any difference. The last column will vary, but in the example I have to prepare, I only have to go up to column DF (and I'd hate do to this manually every time).

Thanks for any guidance!

Hi

Try this

Please Login or Register  to view this content.

rylo

Holy bananas, you're a genius, and saved me a ton of time! Thank you so much!