applescript select range

[Rich Esser]

I see a couple of postings regarding the changes in MS Excel 2004 with
respect to Applescript. I've had to modify a couple of my scripts to
work properly with the new version of Excel. For the most part, my
modifications have worked. However, I am still unable to select a range
of cells. Specifically, in Excel X, one could select columns 6 through
10 with the command:

select range "C6:C10"

Unfortunately, Excel 2004 selects ROWS 6 through 10 with the above
command. Is this something that I am doing wrong, or is it a bug in
Excel that needs to be fixed immediately?

 

[Bob Greenblatt]

I see a couple of postings regarding the changes in MS Excel 2004 with
respect to Applescript. I've had to modify a couple of my scripts to
work properly with the new version of Excel. For the most part, my
modifications have worked. However, I am still unable to select a range
of cells. Specifically, in Excel X, one could select columns 6 through
10 with the command:

select range "C6:C10"

Unfortunately, Excel 2004 selects ROWS 6 through 10 with the above
command. Is this something that I am doing wrong, or is it a bug in
Excel that needs to be fixed immediately?

It does NOT select rows 6 through 10."C6:C10" specifically refers to cells
C6 through C10. If you want to select entire columns, then it should be:
range "f:j". Or, if you really want rows 6 through 10 selected, then try:
range "6:10"