Results 1 to 10 of 10

Automatically run VBA

Threaded View

  1. #1
    Registered User
    Join Date
    03-06-2009
    Location
    Washington, DC
    MS-Off Ver
    Excel 2003
    Posts
    14

    Automatically run VBA

    I have the following VBA code:

    Sub copycells()
    ActiveWorkbook.Sheets("1-a").Select
    ActiveSheet.Range("a1:c20000").Select
    With Selection
    .Copy
    End With
    ActiveWorkbook.Sheets("2-a").Select
    ActiveSheet.Range("a1").Select
    With Selection
    .PasteSpecial (xlValues)
    .PasteSpecial (xlFormats)
    End With
    End Sub
    I want Sheet2-A to update in real time. That is, whenever I add something to 1-A, I want it to automatically execute without me having to click "Run."

    Is this possible?
    Last edited by nmicon; 05-15-2009 at 11:05 AM.

Thread Information

Users Browsing this Thread

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

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