Named range row/column reference

U

Urklnme

thanks. understood, and that does work well.

I would still like to be able to reference within named ranges usin
offsets from the beginning of the named range. Once I have the offset
they would serve as references into other named ranges of a simila
dimension.

*Is there a way to get vStudentNbr and vTestWeek as relative reference
to the beginning of their respective named ranges? *

(yes I am a VBA newbie!! and I am not yet writing the most efficien
code LOL :)
 
B

Bernie Deitrick

You can do anything. To get it from the beginning of their ranges, you
would use MATCH:

Range("TestScores").Cells(Application.Match(vStudentNb, Range("StudentNb"),
False), _
Application.Match(vTestWeek, Range("TestWeek"), False)).Value =
vTestScore

HTH,
Bernie
MS Excel MVP
 
Top