First of all thank you for your help.
Im new at this but I need to complete one project and this is the only thing that I couldnt do
I need to set a Row as a variable that I can use later
After the Macro find a specific cell
That row I need to set as a variable to later use in the print title rows
Application.CutCopyMode = False
.PrintTitleRows = "$2:$3"
Any idea that can help me?