Jump to content
Sign in to follow this  
Ropetin Again

'Go To' Excel Cell

Recommended Posts

Ropetin Again

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.

Share this post

Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.