First attempt at this, so hopefully this is how it works I have a spreadsheet with about 25 tabs and about 200 columns with lots of different widths. As its updated by many the widths get moved about. Before it is released, I run a macro to go through each column in each tab and restore it to its correct width ie along the lines of goto col a, set width 10, go to col B, set widthto 5 etc etc.
It might nor be the best but it works fine until I have to add or delte colums. Thn I have to go through and amend the col width in VBa. Do-able but pain. I though I could set up a table that VBa could reference so that inserting a line or two would only require the table to be amended ie Col Width A 10 B 5 C 25 etc etc Can anyone help with the VBa code both to do this and also another piece to identify the current widths. Thanks -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
