Hide Zero Rows - ZeroingII

SUGGESTED

Hi there,

I am using the ZeroingII Add-In Function to hide zero rows and it works like a charm on one worksheet. However, most of my reports have multiple sheets in the same file. How can I replicate this add-in on all the worksheets? I have tried lots of different combinations (i.e., comma, space, etc.) on the parameter to identify the sheet name, however, to no avail. I am not VBA savvy enough to be able to use it in this case.

Thanks,

Shelley

Parents
  • 0

    Carmen,

    I found this thread doing a search on the topic. I am not having success with applying Zeroing II on multiple sheets. Here is what I have in "Run Addins" on my properties sheet:

    PLPLUGA.A.ZeroingII(Income Stmt ,H,0,1,0,0,0,0,1,0,=)
    PLPLUGA.A.ZeroingII(Advancement ,G,0,1,0,0,0,0,1,0,=);PLPLUGA.A.ZeroingII(WRBS,G,0,1,0,0,0,0,1,0,=);PLPLUGA.A.ZeroingII(WRAM,G,0,1,0,0,0,0,1,0,=)

    When I run the report, I get this error, see attached.

  • 0 in reply to Carol Lord Openhym
    SUGGESTED

    You are missing a semi colon after your first call of the add-in.

    See below:

    PLPLUGA.A.ZeroingII(Income Stmt ,H,0,1,0,0,0,0,1,0,=);
    PLPLUGA.A.ZeroingII(Advancement ,G,0,1,0,0,0,0,1,0,=);PLPLUGA.A.ZeroingII(WRBS,G,0,1,0,0,0,0,1,0,=);PLPLUGA.A.ZeroingII(WRAM,G,0,1,0,0,0,0,1,0,=)

Reply Children
No Data