Select and Name a Range of Cells with Variable Row

I have been trying to select a range of cells from B2 to D_". The _ represents the last row. The code does recognize the last cell in the data range adn I can select the last cell in the range individually, but I can't select the range from B2 to that Cell. I am using about 15 lines of data, but the data will be a lot larger in real uses. I will be doing a Vlookup to flill this range and will have to format the cells to remove the formulas. The Range function may be helpful, but I am unsure how to apply it in this case. this is a portion of an overall Macro.

Please Login or Register  to view this content.

hi, flovettsr, as an option it can be done this way:

Please Login or Register  to view this content.

this will select range starting from B2 and to the last cell with value in column D