width

I get increasingly annoyed with resizing column width in pivot table every time when I drag new field or calculation. My header names go 'funny' and I have to spend time to change width of each column so they are readable again. It is just really annoying. Google says to un-check "Autofit...

Hi, I have a pivot table that references data in another worksheet. For some reason, the size of the pivot tableappears to have increased (from 3 columns width to 5 columns width). Is itpossible to reduce the size back to 3 columns width and then start adding infields as Rows and Labels. My...

Hi I want to change a cell width in vba. So I wrote the code below. I also went to option-->advance-->display-->ruler and change the unit to centimeters. I selected cell A1 and then went to home-->format-->cell width and it gave me 8.35. My questions: 1) why excel did not show measurement unit...

Hi, I am trying to determine the column width but not sure how. What I wold like to do is: If it is smaller than a specific number then auto fit that column If the width is bigger than that number then set the column width to that number Can someone help please. Here is What I have so far...

How can I use ExecuteExcel4Macro to set a column width? The reason I want to do this instead of through VBA is that ExecuteExcel4Macro seems to keep the Undo stack intack whereas VBA will clear the Undo stack. I tried this but it didnt work: Application.ExecuteExcel4Macro...

I have a data representing duct sizes in width and height in 2 columns and length in 3rd column for more than 100 rows. I want to filter them according to their width and height. Help me. My data looks like this W H L 100 200 3 200 100 1 300 200 2 100...

Hello everyone, Needing some assistance on creating a graph that will calculate a priced based on a board dimensions (height x width), but the graph is base on in-between lengths (see below) I found this link but, not quite what im after, any help would be great :)...

Sup everyone, I know the basics of Excel but I have an issue that is beyond my knowledge. I need to have a value populate a cell and change depending on what value I select in the first cell. Here is a picture to clarify In the "bin size" column I am going to have A, B, C, and D. Each one...

Hi, I created multiple Textboxes in a UserForm2 based on a row and values from a worksheet. When a user modify a value in those boxes the format of number is not kept. I would like to keep the number format when user change the value of some of these textboxes but I really dont know how to...

I have developed VBA coding to export contents of cells in a delimited format to a text file. Each line of data must be a continuous string but I am running into an issue with the width limitations of text files. The excess of some lines (that exceed the width limitations) appear below my data...

Hi, I need help working out if a product is Standard, Medium or Large size based on the length, width and height dimension with the following restrictions: <thead style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font: inherit; vertical-align: baseline;">#C7E0F9[/URL] "] Standard...

Hello, I have data that to be split into each different column, however the problem is if I split it using the text to column method it will split every single words to space (column) and I can do it with the fixed width either because it's different width. How do i attach the file to show...

Trying to get and set an image's scaleheight and width msgbox activesheet.Shapes(1).ScaleHeight returns nothing. I realize there are 3 parts to Scaleheight and width Help a brother out? Thanks

Hello all, I have created a file that creates tables and pastes into a Word file. For some reason file pastes tables just fine for me, but for someone else with a different Word configuration is not working properly. I have tried pasting, paste special keeping source formatting and autofit...

Hi all! I've got a calendar in a spreadsheet, horizontal with a column for each day. the cells above each day are as follows: E 1 dd 2 dd mmm yyyy 3 ddd so a real example: E 1 13 2 13 Apr 2018 3 Fri I've got conditional formatting...

Hi All, I need to automatically amend a column width, which is easy with VB. Script supplied below. However, the author of the spreadsheet decided in their wisdom (d'oh!) to incorporate merged cells. Unfortunately, I need to retain these numerous and illogically placed merged cells. is there...

Hi, I am trying to increase the width of each bar in a bar-line chart. I have found various people saying how to do it and the answer does work to some degree but not enough as my bars are still pretty skinny. How can I make them wider still? The method I have seen an tried is simple...

Hi guys, I'm currently using a VBA attached to a button to pull images through from an external source but I want to set up a separate button which resizes the row and column width/ height to 25 and then auto sizes the all images (which are in Row D) to the new row and column/ width. Thanks so...

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