Results 1 to 6 of 6

how can i link this code to another sheet?

Threaded View

  1. #1
    Registered User
    Join Date
    11-09-2018
    Location
    london
    MS-Off Ver
    2013
    Posts
    4

    how can i link this code to another sheet?

    hello i'm new here,
    i do apologize, if i have posted incorrectly.

    i use the code below to log the changes of cell A1 on sheet1, each time the cell is updated the value is put into cellA2 then cell A3 ect. what i need to do is make the log on Sheet2 column A. i have tried to adjust the code to allow for this but cant get it to work.
    thanks for any help.

    Private Sub Worksheet_Change(ByVal Target As Range)
        If Not Intersect(Target, Range("A1")) Is Nothing Then
            Application.EnableEvents = False
            Range("A" & Rows.Count).End(xlUp).Offset(1, 0).Value = Range("A1").Value
            Application.EnableEvents = True
        End If
    End Sub
    Last edited by AliGW; 11-10-2018 at 11:19 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] LINK to specific sheet once logon successfully: HOW TO CODE IT?
    By poizones in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-08-2018, 05:08 AM
  2. [SOLVED] VBA - Link in code to get data from one sheet paste in another sheet.
    By KSveigaard in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-24-2017, 11:44 AM
  3. how to click any link in a website and extracting the new link and text in our excel sheet
    By prahladsingh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-19-2016, 11:55 AM
  4. Replies: 0
    Last Post: 02-18-2016, 07:26 AM
  5. [SOLVED] How to use a hyperlink within the code, when the link is written in a sheet?
    By birbjo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-26-2014, 05:58 PM
  6. Replies: 0
    Last Post: 01-28-2014, 02:45 PM
  7. VBA Code to link to external sheet
    By excelnovice83 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-20-2008, 03:02 PM

Tags for this Thread

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