+ Reply to Thread
Results 1 to 2 of 2

Getting code to work for new copied cells

  1. #1
    Registered User
    Join Date
    02-18-2018
    Location
    Athens, Greece
    MS-Off Ver
    2016
    Posts
    1

    Getting code to work for new copied cells

    Question is simple really.I have some code in the change event of a worksheet with an intersect command.I also have a button on the sheet which when clicked copies a range of cells(for which the code in the change event is written) to a new location in the same sheet.
    Question is how do i get the code of the change event to work for the new range i just copied to with the macro of the button.
    Thanks in advance!

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Getting code to work for new copied cells

    Show your code.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

+ 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. VBA Code to delete blank cells from copied data
    By Jes1397 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-29-2017, 01:42 PM
  2. Testing single code, work fine. Put multiple codes in one sheet, one code doesn't work.
    By MayDay1988 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-30-2017, 06:14 PM
  3. VBA - Macro (Copied Code But Does Not Work)
    By lee2121 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-21-2017, 04:08 PM
  4. [SOLVED] When data is copied to another workbook, hyperlinks as not copied or they don't work
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-17-2014, 06:46 AM
  5. [SOLVED] I've copied a code directly from YouTube but it doesn't work for me
    By PistachioPedro in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-31-2013, 12:52 AM
  6. Replies: 1
    Last Post: 08-14-2013, 12:01 PM
  7. Copied VBA code won't work.
    By ABBOV in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-12-2010, 05:48 AM

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