autofit

  1. M

    VBA to Autofit Row Height on multiple sheets

    I'm looking for a macro that will Autofit row height for cell ranges on select sheets in my workbook. Ideally if the macro could reference a tab with a setup table containing the sheet names and cell ranges to format I think that would work best for me. I'm having difficulty finding something...
  2. N

    autofit wont loop

    hey all does anyone see why this code won't loop to the next open workbook...? it only does it on the current workbook ive selected, and therefore, cannot Call to another macro... ideally, i would rather just have all sheets in all open workbooks autofit from columns "B:Z" but that hasn't...
  3. S

    Range questions - Paste in order and Autofit

    Can I ask 2 quick questions. I selected a range of columns and copied. When they paste into the new sheet however they don't paste in the order they were selected they paste in order of occurrence. here is my code. How can i paste as selected. Dim WS As Worksheet Set WS = Sheets.Add...
  4. A

    Autofit problems in an Excel table

    Hello. I am stuck with an Autofit problem in an Excel table: autofit makes some rows higher even if there are no rows that would have any text that is wrapped in the table. I am trying to make it so the user can click on a button to make everything format properly. The code below gives the...
  5. L

    Word Wrap & Autofit Row Height Stop Working if Lots of Text

    Please note: I've been researching this online for days and have found many threads with a similar issue relating to merged cells, but I'm not using merged cells, so haven't found a solution to this problem. Version: <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office"...
  6. B

    Worksheet Doesn't Activate

    Excel 2003 VBA This is very strange asI am having 2 issues that may or may not be connected or indictative of an underlying issue: 1) I have a number of sheets each with code, some the same, some different, that are attached to the activate event. They tend to turn off...
  7. P

    Autofit all files in a folder multiple sheets

    Hi I wonder if you can help I have searched round the forum but with no luck. I know how to do autofit in a macro and also autofit for a range of sheets but is it possible to do autofit columns for all sheets in all workbooks in a specific folder. Reason I ask is that I have about 25 workbooks...
  8. G

    Re-Sizing Charts in Excel 2010

    I created a new chart as part of an 80 chart file. The new chart is so large that the Chart Title is inside the Chart Area. The Horizontial Axix Title is not visible. When I right click to make adjustments, I see a dimmed autofit box when I click on Size. Where do I find the settings to make...
  9. H

    Autofit Excel table in Word

    Hello- I am using office 2010. I have a macro is excel that copies a bunch of tables and sheets from excel to word. When the table is pasted into the word document the column width is altered. Is there any way to do the AutoFit column feature in word after it has been pasted from excel using...
  10. K

    Autofit row height w minimum

    Sub CCAutofit() Dim rRow As Range With Range("RngOrders").Select Rows.AutoFit For Each rRow In .Rows If rRow.RowHeight < 20.25 Then rRow.RowHeight = 20.25 Next rRow End With End Sub What is wrong here? I want to autofit all the row heights, but keep the...
  11. C

    Target.Address wont triger AutoFit code in Excel 07

    Hi, Im trying to get rows to autofit every time cell b5 changes. Tried several things but still can't figure it out. Thanks In Cell b5, there is a drop-down list via data validation. The data in the range of B10:E61 will automatically change referencing to the same location of another...
  12. T

    VBA - need autofit row height work around for merged cells

    Hi! Apparently I am trying the impossible... I have a spreadsheet that yes, has merged cells (for presentation reasons, I can't change that) and some places need text inserted. WHen I create the "final copy" I need to be sure all text entered can be viewed (because the sheet will then be...
  13. Y

    Using Autofit on Multiple Rows

    This is a follow up to a thread I followed in "How to make a macro run each time a specific cell value changes." That thread helped me understand how to get a macro to execute when a particular cell was changed, but the macro itself does not do what it is supposed to do. The workbook I am...
  14. S

    autofit columns BUT for columnwidth to not exceed 40 ?

    I'd like to autofit columns but not allow the column width to exceed 40 (as some may be 255)... any ideas please? Here's an extract of what I have now: Dim lastCol As Integer Dim lastRow As Integer With ActiveSheet ' find position of entire table including...
  15. M

    text is cut off when printing, looks fine on screen

    When printing a worksheet, the text will not all print as shown on the screen unless I make the cell where the text is larger than autofit suggests. Is there anyway around this, so I don't have to check everything I print? Thanks for the help
  16. D

    Row Autofit with a minimum size??

    Hi guys, I'm using this because some cells have a lot of info: Rows("7:65536").EntireRow.AutoFit But I'm not happy with the single line width... How can I use a minimum width of: Rows("7:65536").RowHeight = 30 Thanks in advance... John.
  17. E

    Fitting columns to text in autofiltered rows

    I've written some VBA to create a new sheet based on a 'master' sheet then autofilter the new sheet according to certain criteria. This obviously hides some of the unwanted rows leaving the text in other rows visible. I now want to change the width of some columns so that they will fit the...
  18. S

    Autofit Cells

    I currently have a matrix - 5 rows down and 3 columns across. The matrix pulls data from another worksheet in my workbook through the use of a macro. Is there an autofit code I can use so that the data pulled is readable, it's rather squished at the moment. The range that I am working with...
  19. B

    Selection.Columns.AutoFit in VBA S-L-O-W

    I have a modest size spreadsheet - about 1000 rows and 200 columns I do a range select : ActiveSheet.Range(Cells(5,2), Cells(1000, 200)).Select 'Then: Application.ScreenUpdating = False Application.Calculation = xlCalculationManual (capture current time) Selection.Columns.AutoFit (capture...
  20. J

    Autofit single cell XL03

    Hi, </PRE> I am using XL03 & XP SP2. </PRE> I am trying to autofit rows, all of which one column has cells that contain anywhere from 0 - 1500 characters. No cells are merged on the worksheet. Each of these cells with content have manual linebreaks in them to designate seperate entries (each...

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
Back
Top