Advanced Dynamic Ranges
(AutomateExcel) The standard dynamic range uses a named range based on the COUNTA formulae:
=OFFSET($H$1,0,0,COUNT($H:$H),1)
However, this only works where there are no blanks in the data. If the data is purely numeric, and contains blank cells in the data then use
Update update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 3651 failed: 1142 [UPDATE command denied to user '334187_hdlns_ms5'@'10.187.248.89' for table 'feed'] in [update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 3651]
updated 3651 (Automate Excel), inserted 0, updated 0, at 2012-05-31 00:58:10
