+ Reply to Thread
Results 1 to 3 of 3

Google Sheet : Time Stamp Code Work Only in Active Sheet Always Rename Sheet

  1. #1
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    Google Sheet : Time Stamp Code Work Only in Active Sheet Always Rename Sheet

    hi all..

    i'm looking for how to make modified this code
    Please Login or Register  to view this content.
    the code only work in sheet "DATA" ..
    i have and work on several sheet into 1 file spreadsheet.
    1. I want to make how the code work in active sheet/current sheet, not necessary every time renaming sheet "DATA" and
    2. When cell/row is blank (no data), the timestamp don't show in col6
    3. the code work start from cell F2 down., not start from row1

    here this link share sheet
    https://docs.google.com/spreadsheets...it?usp=sharing

    any one helping would like appreciated..

    john m
    Last edited by Jhon Mustofa; 11-23-2021 at 03:28 AM.

  2. #2
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,150

    Re: Google Sheet : Time Stamp Code Work Only in Active Sheet Always Rename Sheet

    Try this;

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    Re: Google Sheet : Time Stamp Code Work Only in Active Sheet Always Rename Sheet

    hi Haluk, thank you!! Working well.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [GOOGLE SHEETS] Date Stamp when Sheet is Updated
    By Mightytimbo in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 7
    Last Post: 11-10-2021, 07:03 AM
  2. Synchronize multiple users one particular excel work sheet in google sheet?
    By bala04msw in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2018, 04:22 AM
  3. [SOLVED] Change VBA Code so that it work on All Sheets and not only on Active Sheet.
    By Chypp in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-28-2017, 12:45 PM
  4. [SOLVED] Setting Print area with VBA code on active sheet - Can't get my code to work
    By hans302 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-14-2017, 05:07 AM
  5. Run-time error '1004: Cannot rename the sheet as another sheet as same name
    By narendrabr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2014, 11:49 AM
  6. [SOLVED] Active sheet shifts back to original sheet when executing code
    By pcdog in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 10-22-2012, 11:07 AM
  7. [SOLVED] How to get Range Cells code to work on the non-active sheet
    By skysurfer in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-02-2012, 07:13 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1