concatenating integer and string

testRev2.xlsm

I've written a module (below and also in the attached excel file) to read a series of *.csv files (which I access online) and insert into a spreadsheet. I'm kind of stuck on some basic VBA syntax, specifically, how to concatenate the string "C" with the integer I, to form a string which can then define 'qrow' which is the cell location to write each line of data to. Any insights would be greatly appreciated. Thanks!

Please Login or Register  to view this content.

basically, I'm looping from row 128 to row 7 in the excel file and trying to write the downloaded data to cell location C128, C127... C7.

Please Login or Register  to view this content.