JohnERP
12-05-2007, 03:42 PM
Goal: Find and present in the active window, automatially, a particular cell in a worksheet.
Currently, on a Before Double Click, I have some code that finds the original source (meaning worksheet and cell) of the value from my target cell (which is generally in a different worksheet). Although I can Select the source cell, it doesn't come into focus on the source work sheet window because there could be thousands of rows of data. What syntax/functions can I use to bring the cell (by scrolling or whatever means) into the active window? Right now the user has to scroll around and hope to see the cell in focus.
Any tips are welcome!
Currently, on a Before Double Click, I have some code that finds the original source (meaning worksheet and cell) of the value from my target cell (which is generally in a different worksheet). Although I can Select the source cell, it doesn't come into focus on the source work sheet window because there could be thousands of rows of data. What syntax/functions can I use to bring the cell (by scrolling or whatever means) into the active window? Right now the user has to scroll around and hope to see the cell in focus.
Any tips are welcome!