resize row height

I piece together weekly reports for my team. I keep row heights at a minimum 75.00, 100 pixels and maximum 203.25, 271 pixels. To take a lot of time out of this task and make it automated, I would like to conditionally format (though probably not possible based on my research) or enter a code /...

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

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

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