Hi,

I have a macro setup to import a tab-delimited .txt file. One thing I'd like it to do is insert a row at the top of the "spreadsheet," so I can add column headings. I tried the following code: 
Rows(1).Activate
Rows.Insert(xlShiftDown)
, but got an error message saying that it cannot shift nonblank cells of the workbook. The last row is 189, so I tried adding data to cell A190, then setting it to null, hoping it'd create a new row, but I keep getting the same error. Can anyone provide suggestions as to achieve this?

Thanks,
Chris