ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   create a macro to delete columns and then border remaining columns (https://www.excelbanter.com/excel-programming/393554-create-macro-delete-columns-then-border-remaining-columns.html)

Jane777

create a macro to delete columns and then border remaining columns
 
I want to delete the same columns everytime. On the remaining columns, add
an outside border for each column, then format all date columns ro n/n/nn and
change the width to 8.

Dave Peterson

create a macro to delete columns and then border remaining columns
 
Lots of times the best way to get the code for stuff like this is to record a
macro when you do it manually.

If you do that and have trouble tweaking that code, post back with the recorded
code and the specific trouble you're having.

Jane777 wrote:

I want to delete the same columns everytime. On the remaining columns, add
an outside border for each column, then format all date columns ro n/n/nn and
change the width to 8.


--

Dave Peterson


All times are GMT +1. The time now is 03:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com