Easiest way:

Identify the Name Box, to the left of the formula bar (the one always
showing the address of the selected cell).

Select your range of data. Click in the name box and enter the name
you want to give your range. For more, InsertNameDefine...

HTH
Kostis Vezerides


On Jun 27, 5:49 pm, "Steven"
wrote:
How do I name a range of cells in a worksheet to be used to grab data from
another worksheet?

All this highlighting cells time and time again is a pain in the bum!