column widths

  1. J

    Read and Write Column Width Function

    Since I constantly find myself tweaking column widths after running routines, I thought I would just write code that writes column code. Basically if a sheet is the way you want it, you determine the header row (just for commenting purposes) and run this to build code that figures out all your...
  2. Q

    Dynamically Changing Column Widths on Userform Listbox

    Hello all, I'm using a Listbox to display data from a table. I use a ListCount and an Offset to loop through the range and load each cell individually. In order to hide/show certain columns in the data, I am trying to dynamically change the column widths based on the value in a column...
  3. M

    Same column widths applied to all sheets in a workbook

    Hi all, I have got a printing project that I am trying to save days worth of time in. Currently I have a list of contents in 'Sheet1' (example below): <tbody> A B C D E 2016.2017 New ABC123 Yes Full 2016.2017 Old ABC123 No Half 2016.2017 New DEF456 No Half 2016.2017 New DEF456 No...
  4. L

    How to make Excel report width of columns(s)?

    Hi, I'm looking for a macro or function/formula to list & total a range of column widths. Having lots of columns with varying widths t'would rather not have to do it manually from each column's Properties. Thanks.... Max :)

Some videos you may like

This Week's Hot Topics

  • Check VBA code to locate value in cell
    Hello this is the current code I have [CODE=vba] Private Sub TextBox1_AfterUpdate() Dim m As String Dim rx As String rx = Trim(TextBox1.Text)...
  • Reverse Numbers Formula
    Hello Everyone! My computer is Asus My Operating system is Windows 10. Can someone please help me with a formula that I can drag down (or up) to...
  • Count If Issue
    Hi all, I'm trying to create an spreadsheet which counts certain words in a cell only once and gives me a total. I can do this but some of the...
  • VBA Check for multiple cell values and copy the cell in column A
    Hello! So I have this code that checks for the values in column "L" in this case it's 25. But I want to change this code so that it actually...
  • Sending mails to specific recipients based on a cells value
    Good morning, I am trying to get excel to send out an email to different sales reps. So if row X is an error code of "999" then excel needs to...
  • Matching Number in Textbox
    Hello Excel Users, I come with a request. Hope all are doing fine. So I have 1 textbox to type in numbers etc. 12345 (it will always be 5...
Top