excel function syntax calling error

Question

I've created this function:

Public Function getLastCellValue(ByVal row As Integer, ByVal column As String) As String
If (Cells(row, column).Value = "") Then
    getLastCellValue = getLastCellValue(row - 1, column)
Else: getLastCellValue = Cells.Item(row, column).Value
End If
End Function

When I use it in a cell this:

=getLastCellValue(1,"C")

Excel tells me that the function contains an error and focuses on the second parameter: "C".

I'm going crazy because I do not understand the mistake.

Make sure your Excel language is using the comma (,) to separate functions parameters; if your name tells me something about your nationality, I guess you're using an Italian/Spanish system (which means you should separate inputs by semi-column (;) — Matteo NNZ
– Matteo NNZ, Commented Mar 26, 2015 at 16:01

Community · Accepted Answer · 2017-05-23 12:14:22Z

4

~~Cells(row, column) expects numeric parameter values~~. If you mean to refer to cell addresses (like, "A1") then it might be simpler to use Range instead.

That said I strongly recommend taking this implementation over to Code Review once you get it to work as expected, ...I'd have several things to point out ;)

Your code works as is on my machine. My bet is on @Matteo's comment

Make sure your Excel language is using the comma (,) to separate functions parameters; if your name tells me something about your nationality, I guess you're using an Italian/Spanish system (which means you should separate inputs by semi-column (;)

edited May 23, 2017 at 12:14

CommunityBot

11 silver badge

answered Mar 26, 2015 at 15:58

Mathieu Guindon

71.5k8 gold badges113 silver badges250 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Matteo NNZ Over a year ago

Wrong, it takes the letter as well.

Sobigen Over a year ago

Cells() can use a column's string name. I didn't think it would work either when I saw someone else using it on this board until I tried it. I'm using 2007 for reference.

Mathieu Guindon Over a year ago

@MatteoNNZ The IntelliSense calls the parameters [RowIndex] and [ColumnIndex]... damn Microsoft!

Matteo NNZ Over a year ago

Moreover, the function crashes on the beginning, it doesn't enter the code. I guess he should separate values by semi-columns (;) and not commas (,), it should be related to the operating system

michael Over a year ago

The problem was the comma. The correct usage of function require the semicolumn on my Excel 2011 for Mac, Italian version. MatteoNNZ you win!

|

Collectives™ on Stack Overflow

excel function syntax calling error

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related