Hiding Dynamic Range of Numbers Using Row Numbers

Hello All,

I am trying to figure out how to hide a range of rows that changes. The rows that need to be hidden will be determined in the macro code as a cell value changes. The first row and last row in the range of rows to be hidden will be represented by their row number for example the cell A117 is in row 117. One example of the range of rows to be hidden is 101 through 117:

HideRowBeg = 48+53 =101 (53 is the value in cell A6)
HideRowEnd = 117

I tried this code, but realize that the dimensions defined cannot be used in the range. How do I go about using the defined dimensions in a range or otherwise?

Please Login or Register  to view this content.

I was able to use the following code, but prefer not to because it adds to the time to run the code and I might need to use this code multiple times to hide multiple ranges of rows.

Please Login or Register  to view this content.