Scan through row 1 fields for specified text and record the column in a variable

[wfogel]

Hello,

I get a data file once a week, and I've built a macro to clean it as needed. Unfortunately, my original macro relied on the columns of the data provided to be in the same order each week, an assumption that has proved false.

The code below is supposed to scan through the fields of row 1, find the one containing "source", and record that column in a variable called SourceColumn.

Please Login or Register  to view this content.

Every part of the above seems to work except [SourceColumn = Column]. For some reason, SourceColumn remains 65. I've attached the row that the above code is supposed to read. I appreciate any help anyone can give me, and I apologize in advance if I don't respond to your help quickly. I'm about to hop on a plane.

Thanks so much!

Will

[Mordred]

I may be wrong but it is probably because you have declared Column as an Integer. I believe Column is a reserved word. I may be wrong and someone will correct me I'm sure. Try changing that to a different declaration.

[wfogel]

Thanks so much, Mordred. After I posted, I left for Christmas break, had a minor car accident, and in general forgot about this problem. My apologies for returning to it so late.

I followed your suggestion and it worked. Thanks again!