Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
passing range to function: type of argument is byref incompatible
I'm trying to write some code to traverse a range of cells and, for
each one, to call a function, which returns the address of the nearest cell above the one passed in, with a lower outline level. In the main code, I have: For Each cTempj In rngCAshOP cTempj.Offset(0, 14).value = fncCellAddCASuperiorItem(cTempj) Next cTempj And then: Function fncCellAddCASuperiorItem(cInferior As Range) As String Dim cSuperior As Range Dim i As Integer i = 0 Do While cSuperior Is Nothing and i < 1000 If cInferior.Offset(-i, 0).EntireRow.OutlineLevel < cInferior.EntireRow.OutlineLevel Then cSuperior = cInferior.Offset(-i, 0) Else i = i + 1 End If Loop fncCellAddCASuperiorItem = cSuperior.Address End Function When i run this, i get an error saying the the type of the argument is byref incompatible. Could anyone please give me some help with where I'm going wrong? |
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) | |||
"ByRef argument type mismatch" Error | Excel Programming | |||
ByRef argument type mismatch error? | Excel Programming | |||
Passing range as an argument in a function | Excel Programming | |||
Passing an Array of User-Defined Type to an Argument of a Function | Excel Programming |