Thanks in advance for the help.

I am building a macro and am trying to select a range where the first
variable is constant at CE3 but and the width is constant ranging to
CU but the lenght is the problem. I can't use CurrentRegion because
there isn't a blank border on the sides and there is one blank row
before the end of the data set. I have been trying to use a Vlookup
wosksheet function to select the right side of the ordered pair but am
unable to get it to work. Any ideas?
This is what i have gotten so far. It doesn't work at all but hopfully
you get the idea.
Range ("CE2:CU3")
Offset(0, 1).Formula = "=VLOOKUP(Total,A2:ER500,99)"
Selection.Cut
Range("AH22").Select
ActiveSheet.Paste
End Sub