Named range row/column reference

  • Thread starter Thread starter Urklnme
  • Start date Start date
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 :)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Named range row/column reference 1
Dynamic named range reference from external workbook 2
Named Range maker code 9
Named Ranges Extremely Slw To Calculate 3
Offset Named range in Datavalidation List 4
Unexpected formula generation using named ranges 1
Naming a range 3
Importing named range from another workbook 5

Back
Top