Hello, I am trying to learn what the text inside Parentheses () means. Because of not knowing what it means, I don't know what to properly call it. Just to clarify, I am not needing help with the VBA, I would like to know what the text within the parentheses is properly referred as. The only...
I have a woworksheet which gathers data from an external source and is continually updating - similar to stock prices. I am trying to copy a range of data in i8:i40. Have tried numerous ways but without success. Reading various forums the below seems most logical to meet my needs but i'm...
Hi all,
I have a large spreadsheet pulling results from multiple tabs into one pivot table to track the status of various things. Within this, there are several different rules for several different manufacturers.
I have a current formula in cell N2 which is...
Hello all, I have some code that works in a sub, but I need to use it several times over the course of my spreadsheets timeline. It currently only works on the active sheet, which I also need to change to be the sheet/variable that is called for in the argument when calling the function.
This...
Hi dear forum members,
Is there a formula that would take a cell address and return the corresponding cell reference so I can then use this reference as an argument in other fonctions such as INDEX etc... ?
Looking for a Non-UDF solution.
Regards.
Hi,
I have the following code. However this line of code throw an error message.
col_Arr = return_column(rng_column_loop, previous_Month)
Error message: Compile ErrorByRef argument type mismatch
The function requires range as argument. I passed in range. So why was the mismatch?
thank you...
hi expert..
i need your help, how to combine this 2 argument in single argument :
INDEX($L$2:$L$31;MATCH(A17;$K$2:$K$31;0)+IF(master!F2>0;0;IF(master!F2=0;2;1)))
i want this below formula can be inserted in above formula
=VLOOKUP(I2;master!$A$2:$O$5;6;FALSE)
i have trying to combine it but...
Where ws is a worksheet and LR is the last row, I am trying to add a hyperlink to another location (asheet.cel.Address). The text to display is an array of data that I am trying to find.
When I run this, however, I get invalid call or argument error. Any ideas?
With ws...
Hi,
I have a SUMIFS formula which is working well with the exception of when the sumifs argument is false it returns 0.00 and I would like it to return a blank cell.
I am thinking an additional AND formula after the initial IF argument may be the way to go but I cant get the formula to work...
hello, looking to construct a formula for a four argument statement:
if A1 is > 10, then return .30
if a1 is >=8, but <=10, then return a value that takes 100 / b2,
and lastly, if a1 is <= 8, then return .40
any thoughts please?
Getting Argument Not Optional Error Marked in Red
Dim ws As Worksheet
Set ws = Worksheets("Sheet1")
ws.Activate
Mnth = Me.ComboBox1.Column(1, Me.ComboBox1.ListIndex)
For i = 1 To Day(DateSerial(Year(Date), Mnth + 1, 1) - 1)
ws.Cells(i, 1).Value =...
Please see the file attached
I want to input a formula in cell C5 which will sum data from C2 through to G2. If Mar is selected in C4 then cells C2 to E2 should be added
https://drive.google.com/open?id=1g38lnSEv13xtBiWygeUWddjIRLmTPzLP
The second argument of the sum function should be...
Hi
I wanted to know the synatx of PrinPreview function which is part of Workbook object.
So I went to object viewer and found out that excel define this function as
Sub PrintPreview([EnableChanges])
I have 2 questions please
1) Why sub? the icon infront of the function is green box which...
How do I refine this formula below.
=IF(ISBLANK(A2),"",IF(ISBLANK(C2),"",IF(A2<>"",NETWORKDAYS(A2,C2),IF(C2<>"",NETWORKDAYS(A2,C2)))))
Is it possible to combine the first and second if arguments and the 3rd and 4th if argument?
This formula,=IF(COUNTIF(Arrays!$K$24:$K$27,F4),O$1,""), works great and I arrived at it from much help on this board. The formula looks at the array in the Arrays tab (Arrays!$K$24:$K$27) and if F4 is found there it returns what is in O1 (in this case its apples). Now I want to add another...
The formula below works correctly
=SUMIF(Consolidated!D:D,Table!A2,Consolidated!P:P)
Basically it is saying that if the value in cell A2 of the "Table" worksheet is found in column D of the "Consolidated" worksheet, then sum the values in column P of the "Consolidated" worksheet.
I would like...
I'm trying to avoid stringing together multiple SUMIFS to find the total value of a cell, where two lots of criteria are matched. I have done some research and keep getting sent off an jaunty anglestowards the land of SUMPRODUCT and INDEX/MATCH - Which i've tried but it seems like I'm going...
Hi I encountered the Argument not optional error while trying to run the code below. Appreciate if anyone can point out my mistake. Thanks a lot guys.
Sub Clear_Hyperlink()
Dim Rng As Range, Cell As Range
Set Rng = ActiveSheet.Range("a1:a7")
For Each Cell In Rng
If...
Hi,
I have the following SumIf formula that's not working as I expect it to:
=SUMIF(QRYTasksRcvd!$A$2:$A$1779,'Daily Tracker'!D7,QRYTasksRcvd!$B$2:$AE$1779)
The first argument is referring to the first column of a table of data where column A is the date.
The second argument is the date I'm...
If I want to pass ONE argument to a SubRoutine, I can do this:
Dim MyArray() as Variant
MyArray() = Array("Apples", "Oranges")
Dim i As Integer
For i = LBound(MyArray(), 1) To UBound(MyArray(), 1)
Call SomeSub(Arg:=i)
Next i
What if SomeSub requires TWO arguments? How can I...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.