Thanks you Neil!!

Is it possible to for the "found item" to set a print area around the project-specific table and end the macro in page break view? I again tried using relative references, but I am unable to get the macro set a print area for a "found" search item.

Range("B155:R172").Select
Range("R155").Activate
ActiveSheet.PageSetup.PrintArea = "$B$155:$R$172"
ActiveWindow.View = xlPageBreakPreview

Also, all tables are aligned within the came columns and repeat after one another. Hopefully that helps!