I need to create a custom function for someone else to use in Excel. I can read VB script just fine but I have not done any programming in Excel. To start, I'm hoping to get a shell going. How would I create a function that could be called in a cell as `=@MyFunction(ThisRow)` (or something like that to hide complexity) to do the following:

```
Function MyFunction(Row) 
    firstName = Row.FIRST_NAME // FIRST_NAME is the column label
    lastName = Row.LAST_NAME
    name = firstName + " " + lastName // just an example of an operation
    MyFunction = name // return value
End Function

```

Search online produced some examples where a range is passed into the function. Since this function would be used by someone else, I'd prefer to limit the argument to the current row. Again, above is only a shell to get the function going. Once I have that working, I can proceed with complex operations within the function. 

Example:

```
A1  | B1     | C1
Mel | Gibson | @MyFunction(thisrow)

C1 would produce 'Mel Gibson'

```