Excel Script code to hide unhide rows

[tonywatsonhelp]

Hi Everyone,
I'm very new to Excel scripts and starting back at the beginning again,
I'm finding it hard to code as I have no examples other than the few Excel has to offer, so I'm hoping someone can help me

In Excel online, I'm looking for a script that when run, if rows 10 to 20 are hidden it unhides them, if they are unhidden they hide.
activesheet is fine or if it helps the sheets name is "Looks"
please could someone help me with this so I can get started.

Thanks

Tony

 

[Cubist]

Excel Online cannot run VBA scripts. You'd have to open it on Apps. Something like this.

Sub Hide()
    Dim ws As Worksheet
    Dim rng As Range
    Dim row As Integer
   
    Set ws = ThisWorkbook.Sheets("Looks")
   
    If ws.Rows("10:20").Hidden = True Then
        ws.Rows("10:20").Hidden = False
    Else
        ws.Rows("10:20").Hidden = True
    End If
End Sub

 

[tonywatsonhelp]

Hi Cubist,
I'm sorry i guess I didn't make that clear, I'm using Excel on line and want code written in the Excel Scripts code not VBA

 

[Cubist]

Maybe this.

function main(workbook: ExcelScript.Workbook) {
    const looksSheet = workbook.getWorksheet("Looks");
    const areRowsHidden = looksSheet.getRange("10:20").getRowHidden();
    looksSheet.getRange("10:20").setRowHidden(!areRowsHidden);
}

 

[tonywatsonhelp]

sorry just come back to this after my holiday, this is great thank you for your help Cubist