Instead of using cells(1,1) use your range name such as mine here selects 3rd
row 4th column of my range:

Set myrng = Range("A1", "D10")
myrng.Select

MsgBox (myrng(3, 4))




--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Shazzer" wrote:

I have several named ranges, all the same shape and size.

In another workbook I want to pull through the data from the cell on the 3rd
row, 4th column of each named range.

I don't want to refer to the absolute cell reference as they might get moved
about.

Is this something that can be done easily?

Thank you