View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robin Clay[_4_] Robin Clay[_4_] is offline
external usenet poster
 
Posts: 40
Default Working with Range

This doesn't work in my subroutine:-

-----------------------------
Function MyTest(XRange as Range) as double
......
XMin = MIN(XRange)
MyTest=XMin
......
End Function
-----------------------------

It gives an error "ByRef argument type mismatch"

I don't know -
(a) why, and
(b) what to use instead.

Help, please ?


Regards

Robin