I would think I could access a cell in a (2D in my case) range somewhere in the workbook by something like "=rangename(3,2)" but every variant I've tried throws an error. What don't I get?
I would think I could access a cell in a (2D in my case) range somewhere in the workbook by something like "=rangename(3,2)" but every variant I've tried throws an error. What don't I get?
are you wanting to use INDIRECT? What are the significance of 2D and rangename(3,2)?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
I mention 2D just to make clear why I show the row/column references in the simple example. I'll spell it out further:
Into each cell of one sheet I hope to pull the values from each of the cells in a range in another sheet. Because the range location can vary, I can't hardcode cell references in the form "OtherSheet!B3", etc. Which is why I am trying to use the rangename in the calling cell, and its relative rows and columns, as in the failed guess I cited, which was: "=rangename(3,2)".
It might help if you could illustrate the process using a small desensitized sample workbook. Be sure to manually include the anticipated outcome.
To upload a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks