ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Funtion as Matrix function? (https://www.excelbanter.com/excel-programming/409631-funtion-matrix-function.html)

Dietmar M. Kehrmann

Funtion as Matrix function?
 
(Excel 2003)

Hi, the function

Public Function RVT(zellen As Range, bezug As Range)
RVT = Application.Rank(zellen, bezug,1)
End Function

is usable as matrix function. If I add in the boddy a "+1" the function
works, but not as matrix function any longer. What can I do to create a
matrix function with body

RVT = Application.Rank(zellen,bezug,1)+1

? (It is a minimal example.)


Thx.


All times are GMT +1. The time now is 06:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com