height

Using Excel 2010, I am seeking a VBA method to set the row height of the LastRow My last row is defined as ... LastRow = Range("B" & Rows.Count).End(xlUp).Row I know how to paste to the last row, but the syntax or method to set the height escapes me. I've searched and can't find anything...

Ok_click Dim weight as string Dim height as string Dim bmi as string Weight =txtweigh.text Height =txtheight.text Bmi=(weight)/height^2

I've been racking my brain for a long time on this and I'm absolutely stuck. I have a unique excel file with some issues that I just can't figure out. I have a worksheet, "Form", with drop down user selections, that copies the selection into a second worksheet, "Final" (Final!A22:A25=Form!B3...

Hello friends, I'm rebuilding an extensive spreadsheet containing a lot of macro's. To make maintenance a lot easier I decided to create a pivot table. This works fine, but it doesn't look the way I like. Main concerns are related to 'Subtotals'. They do not show well and for a static sheet I...

Hello all, once again another stumbling block and could use a push over the hurdle. In column "G" I have a description of an item we are to fabricate. Each item to fabricate has at least 2 entries. These would be G1 and G2. There could be more to create the item (i.e. G3, G4, G5 etc..). Then the...

I am attempting to determine where page breaks occur as I am writing to a worksheet. This seems rather simple at the onset. However, I am copying rows from another worksheet and then setting the Row Height to that of the copied row. So the page break can come at any variable place in the...

Hi... I have an userform which only has height 50, and when i call it with simple code userform.show, the userform height will slowly growing into specific value, for example 500. I wonder, is this can be done with Macro VBA? thanks in advance

Hello guys, sorry if the question seems silly but for me it's very annoying... I have just changed the computer provided by my company and on the right of the Excel window (next to the scrolling bar) there is a thin border, this does not allow you to just go on the right limit of the screen...

I have images inside each cell of column C up to 1000 rows. How to resize image with a given height and width in excel cells ? I expect them to be of width = 11.9" and height = 3.9"

Hi, Can anyone help me to remove blank rows in a powerpoint table? This is created when I have moved data from excel to PPT and it cuts across multiple slides, this is due to the limiting factor per slide being the size of the table (height). As it rolls onto the last slide there are a number...

Hello all. I have an inventory workbook that uses data slicers to drill down to specific criteria. The worksheet that displays the inventory has the product models in columns going across the worksheet. The rows going down are the locations where the product is housed. There is a module of code...

Dear Excel Experts, I tried the code below to automatically adjust the row height in merged cell from A10 to G10. For example, if my sentence is justified in 2 lines only the row height will adjust for 2 liner sentences. Then if my write ups could go longer (example: 6 lines sentences) it...

I have 4 excel files which are cover pages for paper folders. All of these files have 1 page to be written whenever creating paper folders. They differ in row count and variations are 10, 12, 20, 31. All files have margins set to 0 and center on page "horizontally" and "vertically" are selected...

Hi everyone, Apologies if this is somewhere buried in the forum, but I need to make some merged cells autofit. I found the code below, which works.. but the cells then become too high! The cells come out at about double the height of what I need them to be. Can you help? Thanks! Public Sub...

I thought I would share some code to move a form to a specific location based on a cell. I found some VBA code from many different postings on MR Excel and other sites, but I wasn't quite happy with the results. So I finally tried a combination of things. One of the annoying things is if the...

Rows in Excel keep expanding their height when I copy and paste om one lace to other in the same spreadsheet. I can roll the mouse wheel while holding down the Ctrl key to change the zoom and it goes back to the way it was. It is just irritating. It even happens when I save the spreadsheet using...

How to set a max row height and the same time auto fit rows with less content than the max row height?

Changing all the files row height to "15" above the top of the letters. Sub test() Dim i As Long, startRow As Long, endRow As Long, rowHeightIncrease As Long Rows.AutoFit startRow = 2 endRow = Cells(Rows.Count, 1).End(xlUp).Row rowHeightIncrease = 15 For i = startRow To...

I have a lot of sheets with over 1000 rows each. Is there a VBA code or macro I can use to do the following. I want Each row to show all the text in the cells but I want a few millimeters of spacing on top of the letters in each cell. Every cell has a different amount of text so I cannot...

I have a big spreadsheet with macros that crunch some numbers and put out results in a new workbook: the workbook is protected, and so are all sheets, but with sorting and filtering allowed. The headers have auto-filter buttons. Issue #1: the auto-filter allows the user to filter, but upon...