I would like to hide a range of rows based on a number in a certain cell so for example in Cell A1 there is a number 2 so I would like to hide rows 4-31 if the number is 12 hide rows 14-31. Below is the section of code I need amending, I basically need the 14 to be cell A1 value + 2 but I cant get it to work???
Rows("14:31").Select
Selection.EntireRow.Hidden = True
Bookmarks