Having trouble inserting rows

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:

Please Login or Register  to view this content.

, 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

This code should insert a row at the top of your sheet

Please Login or Register  to view this content.

HTH

Worked like a charm. Thanks.