A little help vidth a Function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

excelent - 03 Dec 2006 17:59 GMT

I made this function and it works fine
xDate is 1 cell vith a date, xRange is a range vith som difrent dates

Function Vagt(xDate, xRange)
Vagt = Application.WorksheetFunction.Match(Range(xDate), Range(xRange))
End Function

The problem is that i have to use "" to make the function work

=Vagt("L3";"A3:A9";0)

Hav do i change my function so i dont have to use ""

=Vagt(L3;A3:A9;0)

thanks in advance

Reply to this Message

Niek Otten - 03 Dec 2006 18:17 GMT

Function Vagt(xDate as Range, xRange as Range)
Vagt = Application.WorksheetFunction.Match(xDate, xRange)
End Function

BTW:

=Vagt(L3;A3:A9;0) Should give an error, because the number of arguments is incorrect.

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

|I made this function and it works fine
| xDate is 1 cell vith a date, xRange is a range vith som difrent dates
[quoted text clipped - 12 lines]
|
| thanks in advance

Reply to this Message

excelent - 03 Dec 2006 18:49 GMT

Hi Niek it works great now
y i wrote =Vagt("L3";"A3:A9";0) my mistake

i realy use =Vagt("L3";"A3:A9")

but anyway u made my day :-) thanks alot

"Niek Otten" skrev:

> Function Vagt(xDate as Range, xRange as Range)
> Vagt = Application.WorksheetFunction.Match(xDate, xRange)
[quoted text clipped - 20 lines]
> |
> | thanks in advance

Reply to this Message