Need help: Really silly Excel 2004 question
Need help: Really silly Excel 2004 question
- Subject: Need help: Really silly Excel 2004 question
- From: Richard Rönnbäck <email@hidden>
- Date: Wed, 13 Oct 2004 12:53:04 +0200
I need to get the names of used cell in an Excel sheet, like "A1", "C5" etc
I can refer to a cell with such strings if I set it's value, but I cant
figure out how to get that value in return from a cell, neither from the
dictionary or in any of the properties I get in return if I run:
tell application "Microsoft Excel"
set myUsedRange to used range of sheet 1 of workbook 1
return properties of cell 1 of myUsedRange
end
The cell has a range, but I can't figure out how to coerce an Excel range to
string either, so I can't filter the string either.
I could of course check for first column and row index, but I figure there
must be a better way.
Any help or a code snippet would be greatly appreciated
/ Richard
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden