height

I have a spreadsheet where columns A-D are merged and when a significant amount of text gets entered into a cell it wont auto size to show all the text and when I double click in-between the rows rather than expanding to show all the text it shrinks to only show 1 line. I have tried selecting...

Hi, I have some code which takes a range in excel (which changes in size) and then pastes it into powerpoint as a picture. I need some code that will copy the range and paste it as a picture to a specified width or height (one or the other). Whether the picture is sized to the specified width or...

Hi, I have been using a vba code for a while, but I can't get it to work anymore. Not sure what I'm doing wrong. The code should determine the last used cell in column "A". And then it will fill the height or width of the empty space. But the image height cannot be more than H and width...

I did math but it eludes me now so many years after school. In excel in need to work out a formula for calculating the height of piles without a dumpi level or any survey equipment but a tape measure. I have 2 sides and a right angle to work out the 3rd side. I can use the adjacent and...

In my workbook, I give the user the ability to insert a picture file into one of the worksheets. I have code that does this for them, so the sheet can remain protected the rest of the time. I also allow them to change the height of one of the rows in that sheet, in case they need a bit more...

Hi guys, I recently converted to office 365 from 2010 and had a problem when I was resizing one of my Excel charts. Previously (on Excel 2010) I was able to change the width from say 5.45cm to 5.50cm without the height changing (say it was at 10cm). But with office 365 when I change the chart...

Hi When i see the image inserted in a cell thru coding and its height width properties are dispalyed as 2.28 cm and 16.27 cm respectively ScaleHeight and Scale width shows 100% but in the original excel sheet the same image created in the sheet is at 2.12 cm Height 16.27 cm width ScaleWidth =...

Hi all, I was wondering if anyone could help me confirm that this formula, =60.7*height+45.3*weight-2055, was correctly written with the order of operations when put into excel. A2=(60.7*B2)+(45.3*C2)-2055 B2 = height C2 = weight Thanks in advance.

Morning, I have a spreadsheet in which I have inserted a textbox, so that data input is easier for the user (similar to writing in Word). I have set a default size for the textbox, but if the user enters more text than the current default height of the textbox then the text at the top...

Hi All, I ma writing a script to covert a given range into image, i found a code from which was working fine as long as the range was smaller width but the moment i increased the width of the column it is not working, the whole image is not creating. the below is the steps how the code works, 1)...

I have multiple charts with the same series, so I want to write a code where I can just have 1 legend instead of having a legend per chart. I felt the easiest way was to write a code where I can have the legend cover the entire chart area. However, i've run into a problem where the legend...

I’m using the VBA code below to apply AutoFit Row Height to an entire Workbook. <i>Rows().AutoFit</i> At the bottom of each Worksheet in the Workbook, I have a logo in the last cell (i.e. last row, last column). I do not want this row to have the AutoFit Row Height applied. To complicate...

Hi forum, Apologies - I've tried searching through old posts using keywords like VBA, row height, cell value - but I'm struggling to find a previously posted solution. I should know how to do this but I'm somewhat shame faced. I want to change row heights based on content of a column range...

Hi All I have looked a previous threads and not quite got there. I have a worksheet with various merged cell ( yes I have tried to avoid them but the text needs to be left justified so Centre across selection doesnt work) In the end I think I need some code to place into a worksheet which...

Hey all, I'm not sure if this is at all possible, but I figuredif it is someone here would be able to help. I'm trying to find a vba code that will automatically adjust the height of certain merged cells on a single row whenever the text becomes too long and gets cut off. I found a code that...

I asked a question a while ago about making a list of products and then adding sizes that give a price based on a square metre rate. I have been using this for a while but want to know if I can do this but slightly different. In column A I put the product but on a drop down list. In B we put a...

i set all the cells heights to 20, thereafter i typed into some cells which needs taller height due to much words, and with the help of autofit, it automatically increase the cell height. later, i decided to change the default cell height to 15, how do i change it such that the taller cells will...

I would like to set the row height starting from Row 4 to the bottom of a large table that constantly changes.

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

Hey team, my VBA knowledge is extremely little, so hoping I could get some help here! I currently have a worksheet that automatically generates "Total" in a cell when a certain condition is met through an IF function. I now want to increase the row height, font and font size in the row that...