size

Hello All, I'm looking for efficiency so a formula or VBA will work for this. I'm trying to find the best way to create a title that is as close to 80 characters as possible So the title is broken down like this Quantity - Color1 - Brand1 - Size1 - Style1 - Pattern1 - Size2 - Brand2 -...

I know this has been covered, and believe me, I've looked around, but I haven't found a solution yet. I am trying to figure out how to write a recursive function that will give every possible combination given a certain group size. So, if the array is {1,2,3,4,5} and the group size is 3, I...

Hi, In my tool I had to implement an idirect function with linked objects in order to get the image to be called depending on the cell value. It s dynamically changing depending on the product configuration. In order to do that I’ve created a library/master table with tye images exactly fitting...

Hello every one Thanks for accepting me in your respectful forum. I want to merge the contents of several cells in one in way like that : Range("b1")= Range("a1") & Chr(10) & Range("a2") But I want to determine the font size for every line to be equal one in the original cell after SHRINK TO...

I'm look for VBA code to change the font size in a cell based on the number of lines in another cell. I use the following formula to find out the number of lines in the other cell: =LEN(InfoEntry!$B$14)-LEN(SUBSTITUTE(InfoEntry!$B$14,CHAR(10),""))+1 If the result of this formula is "8" lines...

Hi Folks, Sometimes re-sizing a Frame on a UserForm will "warp" the font size in some (but not all) lines of Text or in Control captions. I haven't been able to figure out any pattern(s) to this phenomenon—it just makes things look weird, especially if/when using mono-spaced fonts. It doesn't...

Hi all, l got a below sheet template for my business. l would like to calculate the total price to my customer based on the information below & there are some challenge on it when l decide to use "query & if error" function for returning the result...

Hi, I have a chart may have 1 bar, 3 or even 10 bars as it's dynamic so what I need is a macro that has specific settings like size of bars should be specific size that depends on number of bars, i.e. if chart has 3 bars then the size is ---- and if it's one bar then size should be --- and so...

So I have a "Tool Bar" across the top of my worksheet that I want to remain the exact same size and position except when row 1 is hidden the tool bar should be hidden as well. If I hide columns etc I don't want the tool bar to change size but I can only seem to get it to either not size or hide...

Hi everyone, I am wondering if it’s possible to set column widths to a wider size than the above, using say a range, meaning if the range A1-A17 = column size 10.00 then have A18 –A100 = column size 20.00, I don’t wish to use merge cells or wordwap if possible. Or if not at least simulate...

Two part question. I currently have 6 macros in my workbook will likely grow to +-10. I created a Custom [Ribbon] Tab with One Group With 5 macros in the group, the macro and icons present fine When I add a 6th one, the first three item appear in full size but the last three are stacked one on...

Hi Everyone, I was wondering if there is a way to change the page size of the PDF according the how big the print area is? For Example, I split my sheet and name 3 print areas "B2:J15,B17:J45,B47:J87" now this works fine but each PDF sheet is A4 size sheets, I've seen a lot of PDFS where the...

Hi, I have a range of cells that are fixed in size (the row height / column width cannot change). The text string that goes into each cell is variable and could have anywhere from 10 to 150 characters in it. The cells are currently set for wrapped text with a font size 14 which satisfies most of...

Hello, I am using a loop function to select a range of rows with x marked in two columns, i.e. with two conditions. I have tried many different things putting an And function but noting works. I highly appreciate if anyone can advise If ActiveSheet.ToggleButton1 = True Then...

Hi, I am stuck on the following problem: I have created a VBA Excel Userform that calculates the max and min hole size for a given bolt size. All calculations etc are contained within the code on the form, I have not and do not want to reference a spreadsheet. I’ve added a Combobox to...

Hello All! Got a query which I hope someone can help with.. I have a spreadsheet that I need to create for work due to a new process. Essentially what I need help on is a formula which automatically breaks down the allocation (column B) into packs (columns D-M). Below is a shortened version of...

there are three spreadsheets I use that I would love to be able to force to always open at a specift size [focus]. if a screen location could be specified as well that would be great. is this possible?

I have a shared workbook that is 614 KB. I need to unshare it briefly so I can make some changes and when I unshare the file size increases to 12,158 KB. How can I unshare and not change the file size?

Morning, I'm creating a 1 page document that each column (columns A - I) is a set width. Most of the worksheet is filled with drop down lists that are wordy. Due to the size of each column, you can't read the each item in the drop down to the cell size. I'm looking for a way to increase the...

A co-worker sent me an excel sheet that I am attempting to print. But when I go to the print screen the page size states that it is "Custom Page Size" with an orange dot. So i tried to change it to 11 x 17 but it wont change, it stays at the Custom Page Size. I tried "save as" and I still...