rowheight

  1. T

    Stange .RowHeight results

    I have a very simple routine that uses: ThisWorkbook.Worksheets(proposal).Range("B" & a).EntireRow.RowHeight = 17 to set the row height to 17. When the above line of code executes, it sets the row height to 22 instead of 17. I have two other identical lines of code that should set the row...
  2. K

    Difference between RowHeight and Height

    According to the help file reading .RowHeight and .Height for a single row range should give the same answer. This however does not happen as can be seen from the following: <table width="211" border="0" cellpadding="0" cellspacing="0"><colgroup><col...
  3. I

    VBA Excel RowHeight (Diff-Range)

    Hi All, I have got MS Query written by 7 sheets of Excel (Sun to Sat) each day have got different values comes ..some time 2 rows some time 6rows My following VBA code is working fine , only problem is the row height I restricted to 1: to 6 as you can see in the code given below: I would like...
  4. W

    looping through sheets & amend rowheight

    Hi all, How can I achieve this: I would like to loop through all my sheets & set the row height to 20 on rows starting from row 6 to the last non blank row. Thanks for your help.
  5. G

    How do I automatically hid rows on a cell selection?

    Hi In one cell I have a Data Validation list so the users can choose a question. (Source: Choose, Automation?, No Automation?) If they choose "Choose" I would like to hide rows 59 to 79. If they choose "Automation?" I would like to hide rows 59 to 63. And if they choose "No automation?" I...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    • Replies: 49
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    • Replies: 37
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    • Replies: 35
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    • Replies: 35
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    • Replies: 30
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    • Replies: 25
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top