[jawsscripts] Re: An Excel script
- From: "Martin Slack" <m.g.slack@xxxxxxxxxxxx>
- To: <jawsscripts@xxxxxxxxxxxxx>
- Date: Thu, 10 Sep 2009 23:30:46 +0100
Reed,
This is purely an Excel feature, but if you select the first cell then hit
F8, you enter extended selection mode, and the arrow keys will extend the
selection (one cell at a time) as far as you want in any direction.
Are there any problems with this?
Martin
----- Original Message -----
From: "Reed Poynter" <reed.poynter@xxxxxxxxx>
To: <jawsscripts@xxxxxxxxxxxxx>
Sent: Thursday, September 10, 2009 7:08 PM
Subject: [jawsscripts] An Excel script
> Hi Scripters,
>
> In Ms Excel 2003, there is a Go To dialog where you can select blocks of
> data based on a top left and a bottom right cell.
> For example, in a spreadsheet, you hit F5 and specify A1:G6 and hit enter.
> The block of data is selected.
>
> I want to be able to do the following.
> Go to the top left cell and hit a key to save its coordinates, go to the
> bottom right cell, hit a second key to save its coordinates, put the 2
> saved
> coordinates together in a string and put it into the go to dialog.
>
> I don't know of anything in Excel that will do this for me. So, I thought
> I'd write a JFW script to do it.
>
> I think my process would be to, with a hot key, save the coordinates of
> the
> top left cell to the clipboard,
> With a second hot key, capture the bottom cell coordinates, and put them
> together into a string with the first coordinates once retrieved from the
> clipboard.
> Save this new string to the clipboard,
> Open Excel's Go To dialog and paste in my coordinates.
>
> My first problem is having the script determine the cell coordinates.
> Looking through the functions in the Script Manager, the only guy I see is
> GetCellCoordinates.
> If I am sitting on cell A5, GetCellCoordinates (x, y) returns integers 1
> and 5.
> I need something that will give me a5.
> Any suggestions?
>
>
> Thanks.
>
> Reed
>
>
> __________
> Visit and contribute to The JAWS Script Repository http://jawsscripts.com
>
> View the list's information and change your settings at
> //www.freelists.org/list/jawsscripts
>
--------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.409 / Virus Database: 270.13.89/2360 - Release Date: 09/10/09
11:29:00
__________
Visit and contribute to The JAWS Script Repository http://jawsscripts.com
View the list's information and change your settings at
//www.freelists.org/list/jawsscripts
Other related posts:
