expand

Hello! How do I expand a selection of multiple columns so that they expand by a specific length that I drag the border at? This is ancient annoyance and I don't know how to fix it! Thanks!

I have rather large textbox where a user can type notes and use the return key for spacing, etc. textbox1.value is (example) 1. Problem1. Solution is blah blah blah. 2. Problem 2. Solution is blah blaha blah. 3.etc 4.etc 5.etc The question is how I can parse this line by line to my...

Good morning! I have created a pivot table (round of applause for me please!) I have added additional columns to the raw data but the data is not showing in the pivot after refreshing. I believe this is because the initial area of the pivot doesn't include my last column. Could you tell me...

Hi, I am trying to use an IF formula (which works as it is now) but i also want to do the same calculation if another cell is populated. here is the formula so far: =IF(E36="ON",(E29*0.9)*'SetMix Calc'!$L$60,E29*'SetMix Calc'!$L$60) how can i expand on the above formula to look at D33 also...

Hi there Usually when I am running these reports and I have a lot of text in a cell and I have expanded the cell to as wide and large as it can be, usually I'd only have a handful of rows with this issue in a field, my usual quick fix is to insert a row below where the large is cell is, merge...

Hello All, I've search for hours to this solution but to no avail. I have a big user-form that have text-boxes dynamically appear when the user press the add command button. This sits in a frame called frame1, I was wondering if it could expand with the amount of text boxes that are on the...

Hi I have a range of date cells which cover several years and am currently using the following formula to calculate the number of unique days in a particular year, the dates are in the 01/01/2018 format, in this case 1992...

Hi guys i'm having a few problems with a table. There's a lot of automatic data on it. Users might choose a value, based on that decision, the list would have to expand, which is does no problems as long as it's a range. When I format it as a table, it used to cut off the data at whatever row...

Good Day Folks I have been trying to expand my selection until the occurrence of "Total"(not including) in the same column. The below code gets me to the cell above the occurrence of "Total" but doesnt expand my selection. Range(Selection, Selection.End(xlDown)).Find("Total", , xlValues...

I have this formula that works to be a nonblank average of a column J that matches to a specific answer in column B (A21). Column B has non-numerical values and Column J is the data I'm averaging. =AVERAGEIF(B3:B20,A3,J3:J20) When I try to expand this to eliminate "0's" from the averages, it...

I'm having trouble writing a VBA code to expand a set of rows that are collapsed in a group. While the absolute row numbers are variable, I'm able to obtain the top and bottom row #s that all my desired rows to expand would be contained between, as those rows always have a specific word in...

Hi, I have a wb for data entry. On one ws the data is entered in a table and at the end of the day copied and saved to another ws in the wb with a macro. I would like to protect the data entry ws, but if I do my table doesn’t expand anymore.... Is there a workaround for that? Thank you!

Right now it's saying that my inbox can only hold one message. How do I expand this?

I have four columns and five rows.....I have a formula that works, but there must be an easier way this is what I'm using,maybe it can be condensed. I might want to expand the formula to accommodate more columns, but for now...

When using Sort (and a couple other commands) a dialog box will pop up, the "Sort Warning", and ask you what you want to do? It then gives you 2 options "Expand the selection" and "Continue with the current selection" and by default it starts on expand the selection. So my question is whether or...

How can I get the cells to expand with the size of a texbox. I am entering text and the Activex texbox is expanding with Multiple lines accordingly to the text, but after a period goes over other fields, How can I get the field cells to expand?

Hi, 2nd post of the day :) I am using a macro to allow users to expand and close grouped columns when the sheet is protected, and its works fine UNTIL I save, close it and go back in. When back in the workbook is locked (that's what I want), but when I try to expand the grouped columns it says...

Hello Friends, I need a solution for my complicated requirement. I have specific format of value range. I need to expand the values as individual values. Example: Input - 1to10. Output - 1 2 3 4 5 6 7 8 9 10 this is a simple example. My specific format is **150**155. The ** replaces by any of...

I'm using a sheet that has a column of + signs in the margin to the left the sheet and when you click on them they expand rows on the sheet. You can click them again and it collapses them. What are they called and how do I add these to a new sheet?

I'm working on a project that needs a bit of flexibility in it. I'm building a table that can potentially expand and contract greatly depending on what the user needs. I've figured out how to make columns expand and collapse laterally to meet my needs (getting it done without manually...