resize row height

  1. tlc53

    VBA Code - Macro to Auto Format by hiding and/or resizing rows

    Hi, I have certain formatting (hiding of rows or resizing of a row) that needs to occur if new accounts are added/removed. I will have a macro button which can be run if they make any changes to the accounts. Cell K36 has a count formula and tells you how many accounts there are. Depending on...
    • tlc53
    • Thread
    • accounts excel vba 2010 hide / unhide rows resize row height rows
    • Replies: 9
    • Forum: Excel Questions
  2. XfortunaX

    VBA help to Find Specific text within cell then resize (Not Autofit)

    Hi, I am stuck on what I think should be a very easy part of code but I cannot get it to go and it happens to be the last piece needed. I was hoping to find "Ticket Number" within column E. If the cell contains "Ticket Number" then resize the row height to 112.50 or 150 pixels and resize the...
    • XfortunaX
    • Thread
    • no autofit resize column resize row height specific text
    • Replies: 5
    • Forum: Excel Questions
  3. T

    Dynamically resize row height

    I have a vlookup formula that returns variable text to a cell, some one line others up to 10 lines. I want to know how I can get the row height to automatically / dynamically adjust to accomodate the amount of text returned by the formula I know I can put autofit on the cell however when only...

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