Ropetin Again Posted August 7, 2008 Posted August 7, 2008 It seems like I've been asking a lot of questions lately, but I'm almost finished on my current 'masterpiece', so I'll be shutting up soon! I'm using the wonderful "Excel.au3 v 1.5 (07/18/2008 @ 8:25am PST)" to read from and write to some Excel files, and it's working great. However, it seems I've run into a situation that the UDF doesn't handle. I would like to make a specific cell viewable on the screen, by moving to it. For example, lets say I have an Excel file open, and it is currently on cell A1. I can visibly see on the screen cell A1 through to P40. The cell I'm interested in in Z99. How can I scroll down to this cell, and make it physically visible on the screen? I've tried _ExcelReadCell and _ExcelWriteCell, just in case they bring focus to the selected cell, but it appears they don't.
jvanegmond Posted August 7, 2008 Posted August 7, 2008 (edited) Excel 2003 or 2007? Try getting the object to the cell and doing a .Focus on it. Edited August 7, 2008 by Manadar github.com/jvanegmond
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now