Excel宏可隐藏动态空行和静态行 [英] Excel macro to hide dynamic blank rows and static rows

问题描述

我有一个模板/工作表A1：E201，用作包装清单，第1-7行作为标题，第8,44,100,151行作为子标题。我需要一个宏来隐藏子标题行和任何空白行。我每天得到大约10-20个这些文件
并且按CTRL单击每一行是非常耗时的。我已经为每种类型找到了几种方法，动态和静态，但没有一种方法可以覆盖两者。谁能帮我吗？我正在使用Office 2003 Pro。

I have a template/worksheet A1:E201 that is used as a packing list with rows 1-7 as a header, and rows 8, 44, 100, 151 as sub headers. I need a macro that will hide the sub header rows and any blank rows. I get approximately 10-20 of these files daily and doing the CTRL-click each row is so time consuming. I have found several methods for each type, dynamic and static but none that cover both. Can anyone help me out? I am using Office 2003 Pro.

推荐答案

这是以下论坛讨论Microsoft Excel功能的问题和反馈，我会将您的问题转移到Excel的MSDN论坛。

Hi,

This is the forum to discuss questions and feedback for Microsoft Excel features, I'll move your question to the MSDN forum for Excel.

https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev

我们建议适当发布的原因是您将获得最合格的受访者群体，而定期阅读论坛的其他合作伙伴可以分享他们的知识或从您与我们的互动中学习。感谢您的理解。

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

问候，

Emi

这篇关于Excel宏可隐藏动态空行和静态行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！