Omit Value from MultiValue Parameter iLogic

[Anonymous]

Hello

I have created a MultiValue Parameter with the Sheet names from an embedded spreadsheet. However I can't seem to make it not look at certain sheets.

Is there a way to delete certain values?

I tried skipping an add occurrence (don't add "x" to list) within a for using an if but it doesn't work. 

SyntaxEditor Code Snippet

wb = GoExcel.Application.ActiveWorkbook
Dim sheetNames as New ArrayList
For Each ws In wb.Worksheets
    If ws  IsNot  "x" Then 'dont add this
    sheetNames.Add(ws.Name)
    End If
Next ws
MultiValue.List("TESTLIST") = sheetNames

[SašoPrijatelj · Accepted solution]

Hi,

try to replace

If ws  IsNot  "x" Then

with

If ws.name <> "x" Then

[Anonymous]

This did the trick, thanks!