Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

When I open an Excel file with a large number of cells, I want it to focus the last modified cell, i.e., the last cell in which I entered/changed data the last time I used Excel.

How can I automatically make Excel focus the last modified cell when opening an Excel file?

share|improve this question
    
Do you want this to happen for a specific file or for all files you open in Excel? –  Excellll Aug 13 '12 at 13:25
add comment

1 Answer 1

Assuming that you've saved your work (and do not select other cells or worksheets before closing), Excel already does what you're asking.

Otherwise, you will need to have a macro-enabled workbook to store a variable with the address of the last modified cell. Then, in the code for your workbook (default: ThisWorkbook in VBE), select the range referenced by the variable in the Workbook_Open() function.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.