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
objVelixo.HideZeroRowsAsync [Range]
objVelixo - A variable that represents an instance of the Velixo_NX_Tools.Vba command class.
Arguments
|
Name |
Required / Optional |
Description |
|---|---|---|
|
|
Required |
Targeted Excel.Range For example, |
Example
Dim velixoObj As Velixo_NX_Tools.VBA
Set velixoObj = CreateObject("Velixo.NX.Tools.Vba")
velixoObj.HideZeroRowsAsync Range("'Trial Balance'!D8:E150")