How to call function in loop and save data in cell

Hi Experts,

I have function to convert English to local indian language. It works fine when I tested in excel sheet.

Currently I'm looking for a program that checks for column "A", concatenate cell content of column B,C and D later call convert function getgoolgettransalte and where the concatenated value get converted to language opted. Finally save the content into column 31(i.e AD).

Here is the piece of code written by me, which is not working Could any help me??????

Private Sub Kannada_Click()
Dim ws As Worksheet, c As Range
Dim name As String

   Set ws = Sheets("Member")
   
   Application.DisplayAlerts = False
   

        For Each c In ws.Range("A2", ws.Range("A" & Rows.Count).End(xlUp))
            name = c.Offset(, 1) & " " & c.Offset(, 2) & " " & c.Offset(, 3)
            Cells(Rows.Count, 31) = getGoogleTranslation("name", "en", "kn")
        Next
    
    
End Sub