VBA: Selecting Every 5th Row
(AutomateExcel) Imagine that we have 20,000 rows of data in an Excel spreadsheet:
However, what about if you wanted to cut this data down such as take every 5th row ? This article shows how it can be done. The Row() function gives the number of each row:
The mod f
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:57:43
