What is the address of first cell and last cell of MS Excel 2010?
Share
What is the address of first cell and last cell of MS Excel 2010?
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Answer:
To get the address of the first cell in a named range, you can use the ADDRESS function together with the ROW and COLUMN functions.
How this formula works
The ADDRESS function builds an address based on a row and column number.
Working from the inside out, the ROW function returns an array of absolute* row numbers for a given range, and the COLUMN function returns an array of column numbers.
The ADDRESS function then assembles and returns an array of addresses. When entered in a single cell, just the item from the array is displayed, which is the address corresponding to the first cell in a range.
* By absolute, I mean numbers that track to the entire worksheet, not numbers relative to the range itself.
Explanation:
please
Answer:
lolistics haaaaaaaaaaaaaaaaa