Import textfile to first free cell in row and use right formating

[SalK]

Hello

Hopefully you can help me with this. I have tried several VBA modules made by others but I havent got it 100% right yet. Here is what I want to do.

I want to import a textfile into a sheet that already contains a lot of info.

I want to find the last cell in A row and there import my textfile.

It also needs to use the right format since the textfile data is separated with tabs.

It also needs to be sorted by the data in the first row.

The data in the textfile will have different numbers of rows but not collumns.

Thanks in advance! /SalK

 

[Joe4]

Welcome to the Board!

Check out this link here for finding the last row (if you do a Search, you will come across tons of posts that deal with this question):
http://www.mrexcel.com/forum/showthread.php?t=408192&highlight=find+row

A useful thing to select a whole block of data when you don't know the size of it is to use Current Region, which will select all contiguous rows and columns from a determined starting point, i.e.
Range("A10").CurrentRegion.Select

Most of the other code that you will need you can get by using the Macro Recorder and record yourself recording the steps you want to complete.

 

[SalK]

Thanks for the help.

CurrentRegion.Select was useful and I inserted a blank row between imports and in that way I could use your tips.

/SalK