tag:blogger.com,1999:blog-6799428426680372912.post4897340609761878293..comments2023-11-15T17:26:49.562+05:30Comments on iGoogleDrive: How to get the location of last modified CellKishhttp://www.blogger.com/profile/13751098853627072874noreply@blogger.comBlogger41125tag:blogger.com,1999:blog-6799428426680372912.post-2459776440733954632019-08-21T08:52:22.919+05:302019-08-21T08:52:22.919+05:30Useful article, thank you for sharing the article!...Useful article, thank you for sharing the article!!!<br /><br />Website <a href="http://www.google.co.ke/url?q=https://bloggiaidap247.com/" rel="nofollow">bloggiaidap247.com</a> và website <a href="http://www.google.co.ke/url?q=https://blogcothebanchuabiet.com/" rel="nofollow">blogcothebanchuabiet.com</a> giúp bạn giải đáp mọi thắc mắc.kilihttps://www.blogger.com/profile/17479270972156274089noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-26103147315969942952018-11-06T21:03:53.369+05:302018-11-06T21:03:53.369+05:30This should be a basic functionality for all docum...This should be a basic functionality for all documents, not only Google Sheets but also Good Docs and the rest, and thus it should not be something that the user has to do through "script" thingy, but it should be the default automatic behavior for all documents of all types.<br /><br />When I read a book, continuing reading on the same page I was at is the default behavior.<br /><br />Patrickhttps://www.blogger.com/profile/16360781839139224784noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-42839489378170950372018-10-28T22:49:58.703+05:302018-10-28T22:49:58.703+05:30great
great<br />Anonymoushttps://www.blogger.com/profile/03691586925825286474noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-19309178539874434102018-10-11T18:44:59.030+05:302018-10-11T18:44:59.030+05:30Awesome, thanks for this. Awesome, thanks for this. ckeller52https://www.blogger.com/profile/16118910083949405324noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-21703879113801487992018-06-23T02:41:25.324+05:302018-06-23T02:41:25.324+05:30I had to activate the Set Trigger function as well...I had to activate the Set Trigger function as well. I had a little trouble with line 17 of the my Open function, but I ran the debug, saved it, closed the sheet and then re-opened it. It took about 10-12 seconds after opening but went right to the last cell I modified on line 5487. Sure beats Page Down. Alleluia!!!Anonymoushttps://www.blogger.com/profile/09743236116078876031noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-22696603961022587472018-06-11T09:54:55.568+05:302018-06-11T09:54:55.568+05:30I have some very elaborate sheets with multiple ta...I have some very elaborate sheets with multiple tabs. This works to get it to open to the cell I was last working in, but each tab I go to goes to the top of the page. Is there a way to get each tab to recall the last cell I was in?Anonymoushttps://www.blogger.com/profile/01792352799667400345noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-77694346480890734212018-06-11T09:52:29.427+05:302018-06-11T09:52:29.427+05:30This comment has been removed by the author.Anonymoushttps://www.blogger.com/profile/01792352799667400345noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-29759438924402076812018-02-15T15:21:12.437+05:302018-02-15T15:21:12.437+05:30Thanks, script works fine. Thanks, script works fine. Anonymoushttps://www.blogger.com/profile/07084435549139036924noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-49206033968313833372017-12-17T06:32:33.107+05:302017-12-17T06:32:33.107+05:30Thank you! That did it for me as well, whew!Thank you! That did it for me as well, whew!Richardhttps://www.blogger.com/profile/07121126436900001472noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-22233324010796170572017-11-17T16:35:16.420+05:302017-11-17T16:35:16.420+05:30The only change I had to make to the original inst...The only change I had to make to the original instructions was that after opening Tools -> Script Editor there was a small amount of script already in place:<br /><br />function myFunction() {<br /> <br />}<br /><br />I had to delete this before pasting the script - after that it was as Berwyn says in the OP.<br />Thank you - fantastic piece of script that will save me tedious hours of Unknownhttps://www.blogger.com/profile/03963395315417778315noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-21870892022881177402017-10-14T15:21:08.620+05:302017-10-14T15:21:08.620+05:30any help for us???any help for us???Anonymoushttps://www.blogger.com/profile/00792397840056219281noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-56357240757775472432017-10-14T15:20:44.540+05:302017-10-14T15:20:44.540+05:30me toome tooAnonymoushttps://www.blogger.com/profile/00792397840056219281noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-33559161272600286682017-09-25T00:03:08.340+05:302017-09-25T00:03:08.340+05:30I get TypeError: Cannot call method "getRange...I get TypeError: Cannot call method "getRange" of null. (line 17, file "Code")Anne Phttps://www.blogger.com/profile/14500219346389474366noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-24730797284510808272017-09-22T19:42:27.623+05:302017-09-22T19:42:27.623+05:30You can do a similar thing yourself. Go to the ce...You can do a similar thing yourself. Go to the cell (the one you want to arrive at upon a re-open of the shee), right click and choose 'Get link to this cell'. It will show you a typical spreadsheet URL but also, tagged to the end, will the the cell info. So copy all of this URL. <br /><br />You have to add this copied URL to your browser's list of bookmarks; then you can click Davidhttps://www.blogger.com/profile/14425701472684919829noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-52422610929819518482017-07-07T00:28:30.032+05:302017-07-07T00:28:30.032+05:30Ok, so I know nothing about script editing and am ...Ok, so I know nothing about script editing and am 69 and really do not care to take the time to learn now... BUT if there is ONE person out there who Writes the Script, and then lets us Copy and Paste it in the Cell we want to open, well, that would be great... I do not understand with all the tech out there that Google has NOT given us a button to push "Start here when opening again". Bob from Salty Cellarhttps://www.blogger.com/profile/03525983993083965003noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-20732498709417273932017-07-06T20:41:06.334+05:302017-07-06T20:41:06.334+05:30Thank you, it works for me! but How can i improve ...Thank you, it works for me! but How can i improve it and make it send me to the last modified cell of in every sheet and not of all?Pleinshttps://www.blogger.com/profile/03553415946933226121noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-84791984214915080602017-05-15T21:52:37.540+05:302017-05-15T21:52:37.540+05:30Yep - this did the trick for me as well. Thanks.Yep - this did the trick for me as well. Thanks.Anonymoushttps://www.blogger.com/profile/15911877674573841409noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-83716004781926530122017-05-03T15:58:48.721+05:302017-05-03T15:58:48.721+05:30Awesome, this works for me (original instructions ...Awesome, this works for me (original instructions at the top of the page). I've now got this running on a couple of different Sheets no bother :) Thanksgravitashttps://www.blogger.com/profile/04795497274601773088noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-45800205639968803192017-03-01T17:05:25.213+05:302017-03-01T17:05:25.213+05:30Thank you - finally a method for returning to your...Thank you - finally a method for returning to your last saved point. Thanks for the script Kishan and thanks to Berwyn for the installation guide.Unknownhttps://www.blogger.com/profile/03963395315417778315noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-47584618915069646162016-10-20T15:23:00.012+05:302016-10-20T15:23:00.012+05:30Thanks a lot! It works :)Thanks a lot! It works :)Alejandro Viajerohttps://www.blogger.com/profile/02197366530330113529noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-43442219550635601582016-07-11T12:45:48.266+05:302016-07-11T12:45:48.266+05:30Thanks for the tip! This made it work for me as we...Thanks for the tip! This made it work for me as well.Quinyxahttps://www.blogger.com/profile/07517026874716792341noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-79273601767657604052016-07-01T21:37:24.493+05:302016-07-01T21:37:24.493+05:30It will not work for me. Script runs fine, no erro...It will not work for me. Script runs fine, no errors, but when I try to actually close the sheet and reopen to last save point, nothing happens. It just opens as defaultAnonymoushttps://www.blogger.com/profile/16562085866063211766noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-73862395190519803842016-06-08T23:22:10.880+05:302016-06-08T23:22:10.880+05:30I was able to make it work. You need to configure ...I was able to make it work. You need to configure 2 triggers:<br /><br />- One "onOpen" trigger that runs the "onOpen" function of this script<br />- One "onEdit" trigger that runs the "myFunction" function of this script.<br /><br />See screenshot: http://tinypic.com?ref=zw0201Anonymoushttps://www.blogger.com/profile/07746066196338659790noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-13962488465151759872016-04-09T05:12:15.703+05:302016-04-09T05:12:15.703+05:30Clicking on tools and script editor causes new win...Clicking on tools and script editor causes new window to hang indefinitely.Anonymoushttps://www.blogger.com/profile/06484968546851256715noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-63005343349827597242015-10-28T18:56:22.235+05:302015-10-28T18:56:22.235+05:30I could not get this to work at first. I tried me...I could not get this to work at first. I tried messing with Triggers and whatever I could find, but no luck. Finally I realized I had filters turned on, so I tried turning them off, closed the sheet, re-opened it, and then it worked great! Hope that helps anyone having issues with it. Thanks for the code!Anonymoushttps://www.blogger.com/profile/18373392725048393178noreply@blogger.com