custom function error

  1. G

    Passing a custom functions returned value into Vlookup

    I have a spreadsheet in which I have there is a cell I want the user name to appear. I am using a function in VBA to get the logon name of the user. Function GetUserName() As String Dim lpBuff As String * 25 Get_User_Name lpBuff, 25 GetUserName = Left(lpBuff, InStr(lpBuff, Chr(0))...
  2. E

    Custom Function Returning #VALUE!

    I have created a custom function do perform concatenation of 16 cells that may not all have values in them. The first cell is required so I pass its value seperately. The remainder I pass as a range. The function works fine during testing but then once I save the file and reopen it the function...
  3. BetterBeef

    Set Function Equal to "ERROR" on Error

    I have the following custom function that finds the "nth" time a particular string shows up in a range: Public Function Nth_Occurrence(range_look As Range, find_it As String, _ occurrence As Long, offset_row As Long, offset_col As Long) Dim lCount As Long Dim rFound As Range On Error...

Some videos you may like

This Week's Hot Topics