I have a worksheet that contains (50) identical estimates with one following
the next down the spreadsheet. Each estimate is (24) rows long. AT the top of
the worksheet is a single summary that shows the cost value for each of the
detailed estimates below. I also use the summary to navigate to each detail
estimate by hyperlinking. If I show all (50) estimates, I would have a
minimum length of 50 x 24 rows or 1200 total rows long. Instead of showing
all (50) estimates, I want to only show the estimates the user will be using
and hide all others. Using the top summary, I was going to add a position a
toggle next to each estimate summary row that when pressed will unhide the
estimate the user will now enter data into. If pressed again, the estimate
will go back to a hidden state. So, if TRUE the estimate is unhidden. If
FALSE, the estimate is hidden. Question (finally): What would the VB
statement look like to both hide and unhide a group of (24) rows per
estimate? Assume the worksheet is shown initially with all (50) estimates in
the hide status. Only when the toggle button is first clicked on does the
particular estimate unhide. Any help would be greatly appreciated. Thank You,
JAD