height

What's excel formula for an isosceles triangle sides? The base is 40" the height is 40"?

What's excel formula for an isosceles triangle sides? The base is 40" the height is 40"?

Hi, I have a product that is sold by its size. The width runs along the top of the table and the height down the side. This then forms a price matrix. EG 100 200 300 100 1.00 1.50 2.00 200 1.75 2.50 2.75 300 4.00 4.75 5.25 So if i have a product...

Hi Everyone, I have a userform with a gallery of images in thumbnail size. I am trying to use a second userform that will resize to the size of the image. With the autosize property set to true the image displays at its original size. However, when i set the userforms width and height to the...

Hello, Hope you are well. I have a Userform with a 2100 height. On this Userform is Frame14 with a 2000 height and scrollbar set Vertically to a 1950 height. On Frame14 is 5 different Frames (Frame1, Frame2, ect). What I want to do is if a user clicks the scrollbar the scrollbar should upon...

Is it possible to set the height, depending on number of rows ? Or Find what the listbox height is? I tried using the number of entries, but the height needed is not evenly multiplied. Also, you can't hide the Gridlines, can you ?

Hi - Please advise if this is possible If i know the screen size of my monitor - say my monitor is 20 x 11.3 (1920 x 1080 screen res) - is there a way i can have a formula in VBA that will give me the height and and width of the excel window if it was maximised? The reason why i ask is that i...

Need some help with the following: I trying to only extract the Height from the Size column "L X W X H" Need only the height <colgroup><col width="72"></colgroup><tbody> 60x53x30 </tbody> =RIGHT(O64,FIND("x",O64)) returns: <colgroup><col width="71"></colgroup><tbody> x30...

I'm looking at a way to resize an image placed into a cell so that it does not exceed the cell height or width whilst maintaining it's aspect ratio, in other words as soon as the height or width meets the cell width or height then it stops resizing. I've found this in another post which goes...

Hello, I have a spreadsheet that includes a few columns with a lot of text. To autofit the rows without taking those into account, I wrote the following code, which copies the first 11 columns of each row to row 2001, autofits it, then takes the row height and applies it to the original row...

Hello everyone! I am having problems figuring out a way to stack images or place images vertically on excel. When saying that, I want to insert a picture and have it move directly below the previous image that was inserted. Usually this wouldn't be a problem, however the images have a...

I need to adjust the row height of sheet according to a table shown in a picture. Please let me know the possibilities of what I am trying to is making any sense to you? I have attached visuals for explaining more accurately that what I want to do

I am using Excel 2010 and my data is variable in number of rows and length of text in each cell and Wrap Text is on. What would be the VBA code to automatically adjust row height from $A$3:INDIRECT("$R$&"COUNT(D:D)) to fit text but have a minimum row height of 27. ~INDIRECT() Gives me the last...

I have a text box where I need to show information that can grow from 1 to 3 rows (increase in height). I have other items in the report that don't show this field but others that do. Is there a way to have it grow in height when needed? What property do I need to adjust on the property...

Hi there Does anyone know how to autofit height of merged cells please? Many thanks Renee

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:

Hello all, Back at it again trying to learn more and came across something I'm having a hard time figuring out. I have a workbook that protects all the sheets with vba. I'd like to protect a specific worksheet but still allow row height changes on only a specific set of rows (10-1000). I'm not...

Hi! So I have come across a problem which can be very annoying. If you have a frame that is say 400 height by 800 width and has vertical scrollbar enabled then within this frame is another frame at position top 1 and left 1 of that frame and is height 700 and width 700. Well since the height of...

Ideally, I'd like a Worksheet_Change event. Basically, any Row whose Cell in Column C that is blank should have a Row Height of 6. All others should be 15. My first thought was Conditional Formatting, but that doesn't deal with Row Height.

Hey, I created a 2d column graph that’s dynamic based up on a drop down list. My only problem with it is each individual graph looks completely different as the height I believe is fixed. What I need is for it to be dynamic so it doesn’t try to scale to said height adjustments. Having a fixed...