delete first row

  1. V

    Delete First & Last Line of Imported Data

    Hi All, I am importing some data from a .txt file but the import data's first and last lines are un-important headers and totals which get in the way of how I am using the data. Other than having to manually delete them on each refresh what is the easiest way of automatically deleting them on...
    • vxs
    • Thread
    • delete first row import data last row of data
    • Replies: 2
    • Forum: Excel Questions
  2. N

    VBA excel CSV export skip first row

    Hi everybody, Below is the VBA code i use behind a button to export the current sheet to a semicolon (;) separated txt file. The code works fine as it is, but it also exports the headers in the excel sheet, and I don't want this. I'm new to VBA and I'm quite happy I got the below code to work...
    • NLSSS
    • Thread
    • delete first row excel skip first row skip header vba
    • Replies: 4
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top