ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Global hiding null rows (https://www.excelbanter.com/excel-discussion-misc-queries/1922-global-hiding-null-rows.html)

PierreL

Global hiding null rows
 
I remember using years ago an add-in that would automatically hide and/or
delete all rows that had zero values.
Any clue as to where to find this nugget?
Thanks,
Pierre

Frank Kabel

Hi
for some VBA code:
http://www.xldynamic.com/source/xld.Deletingv1.html

--
Regards
Frank Kabel
Frankfurt, Germany

PierreL wrote:
I remember using years ago an add-in that would automatically hide
and/or delete all rows that had zero values.
Any clue as to where to find this nugget?
Thanks,
Pierre




PierreL

Dank vielmals Frank,
I will use as is, but the package I referred to was some global set of
functionalities such as the one I quoted and were really packaged VBA
performing some analytical functions.
Pierre

"Frank Kabel" wrote:

Hi
for some VBA code:
http://www.xldynamic.com/source/xld.Deletingv1.html

--
Regards
Frank Kabel
Frankfurt, Germany

PierreL wrote:
I remember using years ago an add-in that would automatically hide
and/or delete all rows that had zero values.
Any clue as to where to find this nugget?
Thanks,
Pierre






All times are GMT +1. The time now is 01:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com