| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing a Range to a Function Problem
Hi when I run the TestIt sub below I get an error "Object Required". What
am I doing wrong? Function FindIt(Ranger As Range) As String Dim C As Range Set C = Ranger.Find("BALER", LookIn:=xlValues) If Not C Is Nothing Then FindIt = C.Address End Function Sub TestIt() FindIt (Range("a1:a4")) End Sub -- Regards, Rocky McKinley |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
| Passing a range to a user defined function | Excel Discussion (Misc queries) | |||
| passing a range to a user defined function using a form | Excel Programming | |||
| Passing an unkown range to a function | Excel Programming | |||
| Passing range as argument | Excel Programming | |||
Threaded Mode
