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
    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
    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
    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
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    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