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