Multiply two variable values in VBA

[Farout.DD]

Hi All,
Can anyone help with what basics I am missing from this code, i keep getting type mismatch for .

>>> use code - tags <<<

cell = cell.Value * Sheets("invoicesforxero").Range("H" & current)


Sub place_line_total_for_xero_spreadsheet()
For Each cell In Sheets("invoicesforxero").Range("G1:G7")
current = cell.Row
cell = cell.Value * Sheets("invoicesforxero").Range("H" & current)
MsgBox cell
Next
End Sub

Many thanks in advance.

 

[Farout.DD]

Sorry not sure how to delete this, I started my range to high and it had text in it...

 

[vletm]

Farout.DD
You could test something like below

Sub place_line_total_for_xero_spreadsheet()
    For Each cell In Sheets("invoicesforxero").Range("G1:G7")
        MsgBox cell.Value * Sheets("invoicesforxero").Range("H" & cell.Row)
    Next
End Sub