Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a variable called "cell" which I have dimensioned as a Range. I also
have a function called AdjustForUniqueFormula. When I pass this public variable to the funtion AdjustForUniqueFormula(cell) I get a Run Time Error 13 Type Mismatch. Why is this? If AdjustForUniqueFormula(cell) = True Then Exit Sub Else 'Do Something........ End if Public Function AdjustForUniqueFormula() If UniqueFormulasAdjustChkBx = True Then If Not IsError(Application.WorksheetFunction.Match(cell.P arent.Name & "!" & cell.Address, UniqueCellAddressArray3, 0) - 1) Then AdjustForUniqueFormula = False Else AdjustForUniqueFormula = True End If Else AdjustForUniqueFormula = False End If End Function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pass variable to NORMINSV function to get only mean value | Excel Worksheet Functions | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
Pass a Variable List Of Values To Subroutine or Function | Excel Programming | |||
Pass Variable Question | Excel Programming | |||
publically defined command bar variable problem | Excel Programming |