top of page

excel macro to hide multiple ranges of rows

Tonight, I used the below macro (posted here) to automatically hide multiple ranges of rows on a Excel worksheet.


This vba code is easy to edit, and tonight it successfully hid more than 70 ranges in a few seconds.


Sub Hide()

ActiveSheet.Rows("3:4").Hidden = True

ActiveSheet.Rows("7:8").Hidden = True

End Sub




It will work on whatever worksheet is currently selected in a workbook.




2 Comments


WKDU TRBD
WKDU TRBD
Jan 06

代发外链 提权重点击找我;

谷歌蜘蛛池 谷歌蜘蛛池;

Fortune Tiger…

Fortune Tiger…

谷歌权重提升/ 谷歌权重提升;

谷歌seo 谷歌seo;

谷歌霸屏 谷歌霸屏

蜘蛛池 蜘蛛池

谷歌快排 谷歌快排

Google外链 Google外链

谷歌留痕 谷歌留痕

Gái Gọi…

Gái Gọi…

Dịch Vụ…

谷歌霸屏 谷歌霸屏

负面删除 负面删除

币圈推广 币圈推广

Google权重提升 Google权重提升

Google外链 Google外链

google留痕 google留痕

Like

BFVY IRTO
BFVY IRTO
Dec 28, 2024

代发外链 提权重点击找我;

游戏推广 游戏推广;

Fortune Tiger Fortune Tiger;

Fortune Tiger Slots Fortune…

谷歌马甲包/ 谷歌马甲包;

谷歌霸屏 谷歌霸屏;

מכונות ETPU מכונות ETPU;

;ماكينات اي تي بي…

آلات إي بي بي…

ETPU maşınları ETPU maşınları;

ETPUマシン ETPUマシン;

ETPU 기계 ETPU 기계;

Like
bottom of page