Question 1:
How can I determine the last column of data that I have imported from a text
file?
The line I came up with is:

LastColumn = Range(Columns.Count & 1).End(xlLeft).Column

But, obviously it doesn't work.

Question 2:
How do I increment characters?

When I write a while loop looking for the first cell with no data, I need to
search
cells A1, B1, C1, etc. How do I increment the letter part of the cell
address.

--
Bryan Kelly
Time is the medium we use to express out priorities.