delete row/column and maintain borders/formatting

2 things are wrong with your line:-

You're trying to use the addition (+) symbol to create a string when you have to use ampersand (&).

Secondly, you need to use the Range object of a worksheet, not Cells.

Your statement should look something like this:-

filnavn = "m:\regnskap\skifteksport\" & Sheets("Oppsett").Range("C5").Value & "_" & Sheets("Oppsett").Range("C6").Value & ".txt"

Hope this helps,
Daniel.

Don't understand...

I'm not sure what you mean. Do you mean how to delete just the data from the row/column but leave the row/column itself? If you delete an entire row/column then everything is deleted.