Need Excel AppleScript for Office 2004 for Macintosh
Need Excel AppleScript for Office 2004 for Macintosh
- Subject: Need Excel AppleScript for Office 2004 for Macintosh
- From: Raymond P Reedy <email@hidden>
- Date: Mon, 1 Oct 2007 16:56:29 -0400
This task is a little over my head with Microsoft Office 2004 and
AppleScript.
I have an Excel sheet with fifty-two columns and three hundred rows.
Each row has been populated weekly, but not all rows received data.
Thus I have empty cells in some rows. Thus A1 thru J1 looks like this
for example...
50 25 empty 35 49 empty 29 42 empty 45
and A2 thru J2 like this...
empty 38 empty 25 46 38 empty 40 16 30
What I need to do with the script is make A1 thru J1 look like this...
50 25 35 49 29 42 45 empty empty empty
and A2 thru J2 like this...
38 25 46 38 40 16 30 empty empty empty
In other words, shift cell data left until there are no empty cells
between populated cells. I would like to do this with range A1:ZZ1,
stopping when A1 thru T1 (the left 20 columns) have been populated
and ALL empty cells, if any, are at the right end of the row.
Then when this works, I want to loop through all 300 rows.
Way over my head. Any help would be appreciated.
Thanks,
RayR
Raymond P Reedy
email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden