I looking for a marco to hide multiple rows on a group of worksheets based on a empty cell reference. I have 15 worksheets to do this in and 5 data sheets that don't need to be in this marco all in the same work book. The cell ranges would ie. O7-O40 & O46-O110. These 5 data sheets are data imported from a SQL file. Plus I would like to have a marco to cancel and unhide all. I planning to make both of these run a button on one of the data sheets if possible. Anyone that can help it would greatly appriciated.