Office scripts: How to count cells in range in multiply sheets

[Alfi]

Hi all, i was working with VBA scripts many years but i really dont get how can i run my scripts into office 365. Specially i did i simple script to count cells in range in multiply sheets. see below. But i completely dont understand how to run it in Office script.

Sub SumValueAcrossTabs()
Dim i As Integer
Dim ws_num As Integer
Dim ws As Worksheet
Dim SumRg As Range
Dim x As Long
x = 0
ws_num = ThisWorkbook.Worksheets.Count
For i = 1 To ws_num
 ThisWorkbook.Worksheets(i).Activate
    Set SumRg = ActiveSheet.Range("Q4:Q400")
    Range("W1").Value = WorksheetFunction.Count(SumRg)
Next
For i = 1 To ws_num
    x = x + Sheets(i).Range("W1").Value
Next i
Sheet1.Range("C10").Value2 = x
End Sub

 

[rlv01]

That's because Office Script is different programming language than VBA. My admittedly limited understanding is that the language used is TypeScript, which is apparently a superset of JavaScript.

 

[Alfi]

i'm not sure where to find the object classes and class properties. even if i convert my formula and functions it's still problem to find right classes.

 

[rlv01]

I do not think that you will find much help about office script in this forum. This thread may be of interest to you.

VBA to Office Scripts

I hear that eventually Excel will use Office Scripts, which is based on JavaScript. From my research this is only as a preview on the web version of Excel. Will this eventually be available for the desktop version of Excel? Has anyone started to use this? Will there be a means to convert...

www.mrexcel.com