First Blank Row
I am trying to find the first blank row (assuming, as you stated, that the data is in range A1 and that there are no blank cells in the first column unless the row is blank) through the last row of the spreadsheet and delete them. I have a formula for the second part already. I need a formula (not a VBA solution) since I need the row numbers (beginning and end) returned so I can incorporate it into a longer applescript that is taking a .cvs file output from a GanttProject schedule and doing magical things and then updating iCal (which is automatically syncronized on the web). Right now I have the cells hard coded, but if the schedule changes, the row numbers may change and throw the whole thing off. I would like to try to prevent that.
And I know that VBA routines can be called from applescript, except that this is broken in Office X.