Can't import txt file after macro deleted target sheet once

[obgle]

Hey guys,

I've got a weird (at least for me) problem.

I wrote a macro which works fine and calculates everything it should, perfect so far. Its last row of code delets all the data I've imported into the sheet "RawData" because I want the user to import new data every time and not to use the old ones eventually.

I used:
Sheets("RawData").Cells.ClearContents

Works fine so far, but when I go ahead and try to import a new txt file into that sheet afterwords I can't import any data anymore. The "Get external data" tab is grey then and won't let me import anything. It would work on the other sheets though and when I create a new sheet it works well. Something must be wrong with the sheet after I clear it using my macro and I have no idea what it migt be

Can anybody help me out here?

[patel45]

yes, but attach a sample file with the macro and textfile