Re: Excel scripting question
Re: Excel scripting question
- Subject: Re: Excel scripting question
- From: hciR nellA <email@hidden>
- Date: Sun, 8 Apr 2001 16:58:13 -0800
-- this 'should' demonstrate the idea of getting the next cell
tell application "Microsoft Excel"
Activate
set actRow to Row of ActiveCell
set actColumn to Column of ActiveCell
set nextLowerCell to ("R" & actRow + 1 & "C" & actColumn)
Select Cell nextLowerCell
end tell
On Sunday, April 8, 2001, at 02:05 PM, cheri wrote:
The script is basically extracting information from one excel document
and
processing it into a pivot table in another excel document. I have a
few
places where I need to process the info with subroutines and this is
where
the questions arise ... Does anyone know the excel syntax for
indicating
the next cell directly below another cell? I've tried various things
from
the dictionary, but nothing seems to be working.
- hcir
mailto:email@hidden
Made with a Mac!