VBA to hide rows based on specific cells data

**enelson84** · 03-21-2024, 10:36 AM

Annual Calendar - testing.xlsm

I'm trying to figure out how to create a VBA code for each month in my workbook that automatically hides rows 24-27 if cell B24 is not part of that month.

Example: January cell B:24 = 2/4/24 so it is not part of January so Rows 24-27 should hide. While in March cell B:24 is 3/31 so it is part of March and would not hide rows 24-27.

I have attached the workbook for your review and help.

Thanks

**ranman256** · 03-21-2024, 11:30 AM

paste code into a module
run: HideValAllSheets to cycle thru all sheets to hide the rows

or run: checkHideValue to run only for the sheet your are currently on.

Please Login or Register  to view this content.

**JohnTopley** · 03-21-2024, 11:30 AM

Please Login or Register  to view this content.

place code in "Thisworkbook"

**enelson84** · 03-21-2024, 11:59 AM

Thank you so much for your quick response. This is perfect!

VBA to hide rows based on specific cells data

LinkBack

Thread Tools

Rate This Thread

Display

VBA to hide rows based on specific cells data

Re: VBA to hide rows based on specific cells data

Re: VBA to hide rows based on specific cells data

Re: VBA to hide rows based on specific cells data

Thread Information

Users Browsing this Thread

Similar Threads

Hide specific rows based upon color

Hide rows in a different sheet based on a value (that contains specific letters)

How to hide some rows based on a specific cell value whilst keeping all unused rows hidden

hide rows based on value in specific column

VBA to hide specific rows based on 2 variables

[SOLVED] First unhide all rows - then hide rows based on specific cell value for a range of cells

Macro to hide both rows and columns simultaneously based on data in cells.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions