VBA commands for NX: HideZeroRowsAsync

Visual Basic for Applications macros are supported in Excel Desktop for Windows only.

Description

Asynchronous command that hides rows that only have zero values for the provided range.

See Introduction to Velixo NX VBA commands for general usage information.

Syntax

CODE

objVelixo.HideZeroRowsAsync [Range]

objVelixo - A variable that represents an instance of the Velixo_NX_Tools.Vba command class.

Arguments

Name

Required / Optional

Description

Range

Required

Targeted Excel.Range

For example, Range("'Sheet1'!A1:E80")

Example

CODE

Dim velixoObj As Velixo_NX_Tools.VBA
Set velixoObj = CreateObject("Velixo.NX.Tools.Vba")

velixoObj.HideZeroRowsAsync Range("'Trial Balance'!D8:E150")