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!
Bookmarks