column width resize

  1. T

    Changing Column Width on a protected worsheet

    Hello, I have a worksheet that has several protected cells. Several of the formulas return a long date. I'm running into a problem with making the column width while the sheet is protected. Is there a way to keep the protection and give people the opportunity to modify the column width? I am...
  2. G

    VBA Target Address Select Case Issue

    Hi all, need some help as I do not know VBA. I have a form that my company uses to hire new folks. One of the cells is a Organization selection drop-down. Because of what other items are in that column I cannot re-size the whole column but want the drop-down to be wider when it is selected...
  3. S

    How to find the largest column width and change a range of columns to that width?

    Hi, i'm using an event: Target.EntireColumn.AutoFit, but after i've done the work I want a VBA code to find the largest column width and then change the range of columns to that specific width. PlEaSe HeLp
  4. H

    Column width adjustment: little tricky

    I am using Excel 2007 with real time feeds in 1 of its worksheet. 4 'different' worksheet tab named 'M'; 'M2'; 'M3' & 'M4' are also there but without any macros in it. Due to space constraint in these 4 ws I have been keeping the column widths of the cells as small as required but some extra...
  5. T

    How do I added column widths to this code?

    Can anyone help? I found this code on another thread ("Copy to new worksheets") but i need to to retain the column widths when the new tab is created. Any help would be much appreciated. Sub Create_Report() Dim LastRow As Long, LastCol As Integer, i As Long, iStart As Long, iEnd As Long...
  6. Roopher

    Excel 2007 Crasher in one Immediate Windo Line

    Hello! I just have discovered a surefire way to crash my Exel 2007: Trying to change the .ColumnWidth of 3 columns at once, I receive strange behaviour, and a subsequently forever-looping application. In the immediate window I type: Activesheet.Columns("A:C").ColumnWidth=Array(5,15,50) Can...

Watch MrExcel Video

This Week's Hot Topics

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
Top