inside

Hi all. Can I exclude chart from being locked in a protected sheet? i use dropdown to get chart to compare data. i want chart to be active inside a protected sheet. Is it possible? if yes, how can i do it? (i'm using excel 2007) Thanks

I Have this File with Short Note inside https://www.dropbox.com/s/kq424sszpd7gu6e/Draw.xlsm?dl=0 Hope that is enough info..

Hi all, I'm using Excel 2007 and have a cell that looks like this [$100(-1.2%)] and would like to remove the () and all inside so that it looks like this [$100] Thanks!

Hi I am trying to learn how to call excel function inside a vba code but I got an error message doing the following Sub fillme() Range("a1:c30") = randbtween(1, 100) End Sub any help please. Thank you so much

hi i have a userform with a scrollbar which i need to set to a range of cells. how do i do it?

I'm having troubles figuring out how to put Index Match inside of Vlookup. If I type out my formula as: =IF(A24="","",VLOOKUP((VLOOKUP(A24,Items!$A:$C,3,FALSE)),'[MasterOrders.xlsx]06102018-145622-Ninja'!$A:$C,3,FALSE)) it works correctly. The problem I am at is the table_array...

I have a script that searches for data using a userform, it's working great except for one thing - I would like to search anything within the cell and not search from an exact match like it's currently doing. For example - One of my entries is "BEHAVIOR HEALTH SPECIALIST ASST (BHSA)"...

Hello, I'm currently working on a line of code where I need to reference in A1 style inside a RC formula. If Range("F" & i).Value = "" Then For j = 2 To 4001 Step 4 Range("L" & i).FormulaR1C1 = "=((rc[-2]-r[-2]c[-2])*("AH14")*24)/1000)*rc[-6]" Next j The cell AH14 is the one I want...

I have as simple module which changes the font based on the name I select inside my worksheet. The code works well when I'm in the VBE and press F5, but when I'm in the worksheet and select a choice in the cell like "YES", the font reverts back to the default font. I know I'm doing something...

I thought this would be super easy-peasy. But man I am stuck. I have a Word table - that has formatted text (bold, italic, indents, bullets, and carriage returns inside the cell) that I need to preserve. I'd like to be able to put that inside a spreadsheet. But when I copy-and-paste, it...

Hello, I want to load my comboboxes dynamically. I have four comboxes and I am loading them with I rowsource. What I want to do now is that, when I select an item from the first combobox, then inside the second combobox, show the list from the first combobox except the one selected in the...

Good Day Thanks to note i have current open subject in Excel forum under the following link https://www.mrexcel.com/forum/excel-questions/1047799-maximum-value-repeated-unique-code.html#post5031325 I already reached partial results in the excel forum with full support with our colleagues...

Why does this formula return #REF ! when entered into a table where the formula is referencing cells outside of the table and inside of the table? =IF(H75="A", IF(Z75<S6,K75*Z75, IF(AND(Z75>(S6-1),Z75<(T6-1)),S75*Z75, IF(AND(Z75>(T6-1),Z75<(U6-1)),T75*Z75, IF(AND(Z75>(U6-1),Z75<(V6-1)),U75*Z75...

I have two formulas. But both of them are not working in the right way. the first formula is: =IF(COUNTIF(G31:G37,$E54),$F54,0) issue: It is not able to read a cells were inside are more than 1 letters. (E54=X) So the main problem that I have with this formula is that is not able to read a...

Sub COPYonRowsAndColumns() ' PLEASE help me to make this easier Range("BB1").Select ActiveCell.FormulaR1C1 = _ "=SUM(--(MMULT((RC11:RC12=R88C54)+(RC11:RC12=R88C55),{1;1})=2))" ' =SUM(--(MMULT(($K1:$L1=$BB$88)+($K1:$L1=$BC$88),{1;1})=2)) ' inside cell...

Hi I need to extract the text from inside the " " Example: 1^/CLIN["KATHERINE"], <tbody> 1^/CLIN["PETER"], </tbody><colgroup><col></colgroup> Can you help please? Kind Regards Katherine

I have a big file with many formulas. currently, it is too slow. because my predecessor has used whole column reference inside formulas. i want to change the whole column references to either Excel tables or dynamic named ranges. so my question is, which one should i use to make my excel work...

What I'm doing here is parsing a JSON file into a worksheet. The JsonConverter example shows it looking through a defined list of "values": ' Prepare and write values to sheetDim Values As Variant ReDim Values(Parsed("values").Count, 3) Dim Value As Dictionary Dim i As Long i = 0 For Each...

Hello to everybody, I have the following issue. Through 1000 points (X and Y) I did a parabola graphic, now I would like to know if a put a series of points (always X and Y) into graph, if those points are inside or outside the parabola. In case one of them is outside, putting the cell in red...

Hello Experts - I have below code which transfers the file (Gross Contribution Report) inside the subfolder (and override the same file inside this subfolder). However, nothing is happening whenever i'm running below code. Can someone help me understand what's wrong. For visualization purposes...