1. B

    VBA Code to Speed Up Hiding of Blank Cells/Rows in Specific Row Ranges

    Hi, I have put together this code to hide all blank cells in certain Row ranges across an array of worksheets. It works ok, but it seems to take some time to complete and uses alot of computer resources to run. Is it possible to use alternative VBA code to be more efficient and speed up the...
  2. dss28

    Userform to autofit window size of any user

    I have developed a program having userforms all in one size of 450 (height) x 780 (width), userform zoom property set to 85. I used the following code to autofit the form to users window size. However some portion of the form is not visible and goes out of window which can not be seen. can we...
  3. J

    Making a Merged cell autofit with using wraptext

    I have an issue I'm hoping you guys can help with. Basically, I would like excel to wrap within a dynamic merged box, kind of like you would get if you were typing into a word document. Does that make sense? I know if you just use wrap text, the system automatically adjusts the height of the...
  4. C

    vba autofit doesn't work on wrapped text cells

    Hi I have a sheet that has variable amount of text in column A. The text is fairly long, it's a paragraph. These cells are wrapped text. The issue is when i do an autofit (either via VBA or even when i do it manually), the autofit works for few of the cells but some will have extra space at the...
  5. N

    AutoFit Row height with cells that have a formula

    Hi all - whenever I used AutoFit Row Height on a row that is referencing data from another sheet(Lets say, Im on Sheet1 and Cell A1 is referencing Sheet2!A7), the row height does not expand to fit all of the text. Is there a simple way to get this to work? Obviously there is no problem when...
  6. S

    AutoFit Row and add 5 to row height via VBA

    I have a spreadsheet w/ vba coding to format the sheet via command button. It will autofit the row height, but when printing it cuts off the of some of the cells that contain a lot of wording. Is there a way to have it autofit and also add 5 more to the height via vba?
  7. D

    Autofit Row Height not working on a cell containing a formula

    Hey folks, I've got a spreadsheet which uses formulas to keep the data in a single ("master") location, with the "alternate views" simply displaying the contents of that master cell. However, I've discovered that in some cases the Autofit function for rows (autofit row height) doesn't correctly...
  8. E

    Help with power query

    Hi I hope someone can help I have a spreadsheet that draws data from other sheets through a power query. Questions: 1)How do I autofit row height each time the query runs? 2) can I include data on the top of the source sheet above the data table and not have it included in the final query...
  9. G

    Autofit Column width works of first sheet but not second sheet

    I am trying to make my table columns autofit to width. I have the following code which works on the first sheet with Table1 but after the next sheet is copied and becomes the active sheet the next line errors out with "Application defined or object defined error" and will not autofit the...
  10. D

    Formatting cell size

    I have a spreadsheet where columns A-D are merged and when a significant amount of text gets entered into a cell it wont auto size to show all the text and when I double click in-between the rows rather than expanding to show all the text it shrinks to only show 1 line. I have tried selecting...
  11. N

    Column Width in VBA

    I am trying to create a button through VBA Code that allows me to autofit every column in a worksheet based only on the range of cells that has numbers in it (Ie. prevents autofitting based on headers). I found a video online that gives me the following code but it needs to be modified in order...
  12. dannyok90

    Autofit Columns VBA

    Hi all, Just wondering if there is a way to autofit columns but keep its current size if the new contents don't extend beyond its current width? Thanks, Dan
  13. R

    AutoFit Row Height through last row with data (VBA)

    I’m using the VBA code below to apply AutoFit Row Height to an entire Workbook. <i>Rows().AutoFit</i> At the bottom of each Worksheet in the Workbook, I have a logo in the last cell (i.e. last row, last column). I do not want this row to have the AutoFit Row Height applied. To complicate...
  14. C

    Automatic height adjustment of merged cells across worksheet

    Hi All I have looked a previous threads and not quite got there. I have a worksheet with various merged cell ( yes I have tried to avoid them but the text needs to be left justified so Centre across selection doesnt work) In the end I think I need some code to place into a worksheet which...
  15. gheyman

    Access: Table Column Width

    I have a Split form where the table format is shown on the bottom half of the form. Is there a way to "autofit" or size the columns size when the form is refreshed or opened?
  16. V

    VBA Code Created In Excel 2016 Running Slowly

    Hi Guys, I m new to VBA ode and created a tool where I have code linked to a active x control button that clears certain cells in my xslm workbook. The problem I am having is the tool is running slowly once the button is clicked. Private Sub CommandButton13_Click() If MsgBox("Do you want...
  17. J

    Autofit Height for Selected Cells Only

    Back in 2003 one could select just a few cells and use autofit row height for the selected cells only. It might come out too small for other cells in the row, but sometimes that doesn't matter (such as when the cells that don't fit are hidden or excluded from the print area). I can't find how to...
  18. G

    AutoFit row height in multiple merged cells

    Hello, I have a spreadsheet where based on what value is input, certain cells are hidden. Most all of my rows contain merged cells. I am looking for a code that will autofit my merged cells and still allow them to be hidden based on other code. I found a code where the autofit works, but the...
  19. S

    Macro VBA to Autofit row height of merged and un-merged/normal Cells

    Hi Everyone, I have a worksheet (ranges A7 to F90) which contains a mix of merged and un-merged cells in each row.. What I would like to do is to create a button in which it will autofit the size of the rows based on the highest row size for both merged and un-merged... I have already prepared...
  20. R

    Autofit height of merged cells

    Hi there Does anyone know how to autofit height of merged cells please? Many thanks Renee

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