Results 1 to 6 of 6

Activating Macro When Last Cell In Column Is Changed

Threaded View

  1. #2
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,957

    Re: Activating Macro When Last Cell In Column Is Changed

    expanding table
    Is this an actual list object or range?

    Perhaps this...
    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column = 9 Then
        Application.EnableEvents = False
        If Target.Row = Cells(Rows.Count, 9).End(xlUp).Row Then Call lasttrade
        Application.EnableEvents = True
    End If
    End Sub
    Last edited by Sintek; 04-29-2021 at 10:20 AM.
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Keep Cell (Row & Column) format unchanged when activating VBA command button
    By Chris1976 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-10-2020, 03:33 AM
  2. Replies: 0
    Last Post: 04-09-2020, 09:34 PM
  3. [SOLVED] Activating a file in a macro by referencing a cell in a workbook
    By Mrs F in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-10-2013, 04:50 AM
  4. Replies: 0
    Last Post: 02-24-2012, 09:12 PM
  5. Activating/De-Activating Comments or only if the Cell is Active.
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 08-31-2011, 11:08 AM
  6. Activating the next column cell from the last active cell
    By teachMeExcel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-18-2008, 06:34 PM
  7. Activating a macro after a cell is updated
    By mecg96 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-03-2006, 05:15 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