worksheetfunctions

  1. L

    passing Range name as an argument to WorksheetFunction

    Hi The code below for some reason does not work. I tried to pass the range between " " but did not work. Any help would be appreciated ' did not work either Cells(1, 3).Value = WorksheetFunction.Sum("myrange") Sub worksheetfunctions() Range("a1:a20").Name = "myrange"...
  2. J

    vba arithmetic between ranges without looping thru each item

    Consider the function xyz Function xyz(Opn As Range, Clo As Range, Wts As Range) Dim MaxOpnClo As Range MaxOpnClo = Application.WorksheetFunction.Max(Opn, Clo) xyz= Application.WorksheetFunction.SumProduct(MaxOpnClo, Wts) / Application.WorksheetFunction.Sum(Wts) End Function As...
  3. R

    Worksheet Function of part of ARRAY

    Hi All, I am running a percentile function on an array of data. My array consists of Past 5 years of data & i am looking to calculate percentile on values for each year. In Excel sheet, I could refer to the Rows for each year and do it. But now i have to create it as a function in VBA. Is...

We've detected that you are using an adblocker.

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.
Go back
Back
Top