manman89

SELECT AND ACTIVE SHEET BY NAME - GOOGLE SPREADSHEET

Dec 2nd, 2012
191
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. function Test(){
  2. var name = "vCron v1.0";
  3. SpreadsheetApp.setActiveSheet(SelectSheetByName(name));
  4. }
  5. function SelectSheetByName(name){
  6. var ss = SpreadsheetApp.getActiveSpreadsheet().getSheets();
  7. for(var i=0; i<ss.length; i++){
  8. if(ss[i].getName()==name){
  9. return ss[i];
  10. }
  11. }
  12. }
  13.  
  14. http://blogger.hide.vn
Add Comment
Please, Sign In to add comment