VBA vs Google sheets

in #excel8 years ago (edited)

A have a VBA module for xlsx file. Does anyone know how to convert it to make it usable in Google sheets?

Function oNumberss(RNG As Range) As Double
Dim RegEx As Object
Dim ssl As String, S_Summ As Double
For n = 1 To RNG.Columns.Count
For m = 1 To RNG.Rows.Count
ssl = ssl & RNG.Cells(m, n)
Next: Next
Set RegEx = CreateObject("VBScript.RegExp")
With RegEx
.Global = True
.Pattern = "\D"
ssl = .Replace(ssl, " ")
End With
Set objRegEx = Nothing
ssl = RTrim(LTrim(ssl))
sl = Split(ssl, " ", -1)
For n = 0 To UBound(sl)
If sl(n) <> "" Then
S_Summ = S_Summ + sl(n)
End If: Next
oNumberss = S_Summ
End Function*

Coin Marketplace

STEEM 0.20
TRX 0.14
JST 0.030
BTC 67975.29
ETH 3240.67
USDT 1.00
SBD 2.66