row height

  1. YetAnotherDave

    Question about pasting specific cell information from clipboard using VBA

    Everyone is familiar with the "Paste Column Widths" command that will take information from the clipboard and use it to transfer the column widths of a copied range to another range without including the actual data from the cells that were copied. Thus, it seems to me that when a range of...
  2. B

    Set Row Height of n+nth Rows Only If Previous Cell Has A Value

    I need to set the row height of specific rows, starting at Row 33 and ending at Row 2208, with the offset of each row from the last being 29. It must only perform the row height change if there is a value in the previous cell in column B. i.e. Set Row Height for Cells B33, B62, B91, B120...
  3. B

    How To Make This VBA Code Faster To Hide Upto 2200 Rows & Set Certain Rows at Specific Height If more than 60 Characters

    Can Excel Top Gun here help a rookie out and let me know if there are a better/faster way to perform the same action? This code works, but its slow and can take around 3-4 minutes on a laptop with i7 12th Gen processor & 64Gb RAM. The process is to hide the entire row if the respective cell in...
  4. K

    Macro to amend row height

    Hi there, I am trying to hide rows in a spreadsheet with no success and am hoping a macro will help. I have the first column with the date but do not want any lines which are the following month to show. In the image all rows are needed however for a shorter month they are not. I want to add a...
  5. M

    Wrap text and automatically adjust row height help

    Is there a way to ensure the text in a cell wraps & automatically the row height adjusts? Right now I find the I can the text to wrap but I have to manually adjust the row height or the text gets cut off but the cell bottom.
  6. F

    Cell/Row height auto fit dynamic text content from alternative worksheet

    I've spent some time searching the forums here and while there are many similar queries, nothing quite fits for me. I have a two column multi row table. Column A is a list of names, and Column B is every job that person will do, therefore all the items in Column A are a single name, but each...
  7. N

    Autosize Row Height based on Visible cells only

    I am trying to Autosize Row height based on Visible cells only and not the Hidden columns. I have columns that has very long text that I will be hiding and then I am left with extra white space in other cells and extra long worksheet. I tried formatting the Autofit cells Row height but, it...
  8. D

    vba row size for workbook sheet

    Im updating a sheets rowsize but when its saved, the size of each row isnt adjusted. Any Ideas? Thanks wb.Sheets(1).Range("U:U").ColumnWidth = 10.56 wb.Sheets(1).Range("W:W").ColumnWidth = 50 wb.Sheets(1).Range("X:X").ColumnWidth = 50 Set targetRange = Range("A:A") For...
  9. B

    Row height change if less than....

    Is there a way to get a row to resize if it is below acertain height? I have my rows in a range set to 38 but I have them autofitting once the day is entered in case the row needs to be taller. Is there a way for this to either only resize if it is goingto make it taller OR after the AUTOFIT...
  10. P

    Noob needing help on conditionally hiding rows based on condition of cells

    I have a complex spreadsheet which has a summary report. There are perhaps 200 populated rows on the summary, but for clarity I wish to set row height to hidden or 1 based on what is in the row. For example, in row 45 if cell B = " " I would like that row hidden or compressed. Row 46 may appear...
  11. K

    VBA Or Macro Help on adjusting row height on gnatt chart based on cell value?

    Hi, I'm looking for help on finishing up my gnatt chart by applying a format to widen row height based on an input cell. For instance, the row height would adjust for the project schedule phase, based on the number of staff assigned (entered in a column for that same row) that would...
  12. A

    Autofit Row Height of Visible Cells Only (including merged cells)

    I am trying to autofit the height of cells (including merged cells) for visible rows only when I have filtered a set of data. Below I've listed cell references: The range of cells A2:A19 are all merged together as one (and there are about 5 lines of text within that group of merged cells)...
  13. K

    VBA to continously update row height as cell changes

    Hey all, Remember I did this years ago, but now I cant get it to work, nor find a similar question in the forum. I'm generating a list where the cell content change a lot from row to row depending on the user input. The list is mainly generated via validation lists, sometimes there's a lot of...
  14. MrDB4Excel

    Styles and row height

    Is it possible to create an excel style to force row height? In the spreadsheet I am working on I use a row height of 8 and a specific color to separate specific data sets. When I begin to input the next data set I skip a row to input data in subsequent rows. Then I go back and adjust the height...
  15. E

    Is it possible to prevent a text box from automatically stretching?

    Here's my situation. I have a text box in column A. In the columns to right is where my data is entered. Sometimes the data in those cells are wrapped into multiple lines, which automatically increases the row height of those cells. I have no problem with those cells adjusting their row height...
  16. M

    Format every fouth row height

    I have a number of large spread- sheets. I need to format the row height of every fourth row to 24.00 I have the macro below which doesn't work. Can anyone fix it please? Sub Height() X = 0 Do X = X + 4 Rows(X).RowHeight = 24 Loop Until X = 1000 End Sub Thanks Steve..:mad:
  17. S

    Row Height adjusted based on content via code or Macro

    I have a worksheet that contains two cells that are populated via a series of nested IF statements based on the contents of another cell. The issue is that one of the statements generates a MUCH longer text string than the other two options. To make the text appear aesthetically pleasing, the...
  18. M

    Dynamic autofit row height

    Hello there everyone, i recently came upon something that im not able to figure out and haven't had any luck after searching a bunch for my particular issue.. my dilemma is that ive created a table so that you can re order based on certain columns and data, etc. and within this table i have...
  19. L

    Specify Minimum Row Height And Autofit Row Size for ALL worksheets

    Hello experts, I have a workbook with the same kind of data in about 30 different worksheet tabs. I want to make all of the rows with data in each worksheet be reformatted with a row height of 30, unless the content is larger than 30 then it needs the entire row to be autofitted. I have code...
  20. L

    Autosize Row Height VBA Macro

    I have a worksheet called "Selected LP List" and on that worksheet, there are index(match()) functions in columns A:F that returns text linked to another worksheet. The problem I am having is that the rows do not automatically adjust the height so any wrapped text is cut off. Typically, column F...

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