Excel 2004 question
Excel 2004 question
- Subject: Excel 2004 question
- From: Christopher Stone <email@hidden>
- Date: Sat, 17 Jul 2004 14:09:30 -0500
Hey Folks,
I can't seem to extract the cell address of a and b in a sensible fashion.
tell application "Microsoft Excel"
tell sheet 1
set a to first cell of used range
set b to last cell of used range
end tell
end tell
a = range "$A$1" of used range of sheet 1
b = range "$K$50" of used range of sheet 1
Is there a better way than:
tell application "Microsoft Excel"
tell sheet 1
set a to <<class seld>> of (first cell of used range as record)
set b to <<class seld>> of (last cell of used range as record)
end tell
end tell
a = "$A$1"
b = "$K$50"
Thanks.
Chris
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.