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...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top