cyrilbrd
07-06-2015, 01:50 AM
Given in cells A19 to M39 a table with data
Headers are in Row 18
Rows 19 to 23 are visible
Rows 24 to 39 are hidden
I would like to set a VBA that would unhide 'x' number of rows or hide 'x' numbers of rows, maybe through a pop up window.
My intent is to be able to show either only one or more rows in the range 19:39
For instance one row would show only row19, 10 rows would shows range 19 to 29...
Looked into the following without much help so far:
.Rows.Hidden = False
.Rows("19" & ":39").Hidden = True
Headers are in Row 18
Rows 19 to 23 are visible
Rows 24 to 39 are hidden
I would like to set a VBA that would unhide 'x' number of rows or hide 'x' numbers of rows, maybe through a pop up window.
My intent is to be able to show either only one or more rows in the range 19:39
For instance one row would show only row19, 10 rows would shows range 19 to 29...
Looked into the following without much help so far:
.Rows.Hidden = False
.Rows("19" & ":39").Hidden = True