I have a vba code to name ranges.
However, to work correctly, the phrase it identifies "Continental U.S. Ground" has to be 2 lines above the phrase "Weight (in Lbs )".
Is there any way to identify these two phrases in Column A and remove any additional lines between them?
Needs to be in column A on sheet "Net Rates 1"
"Continental U.S. Ground"
"Weight (in Lbs )"