MrExcel Publishing
Your One Stop for Excel Tips & Solutions

delete row/column and maintain borders/formatting


Posted by Coline on November 05, 2001 8:47 PM

Is it possible to delete a row/column and maintain formatting like borders?
Thanks.


Posted by Paul Akkermans on November 06, 2001 12:16 AM

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.

Posted by Dan on November 06, 2001 5:19 AM

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.