i am trying to have a change in the range of a worksheet to activate a macro that copies, paste and sort the data from that range into another one. the copy/paste/sort macro portion works well but the code to detect the range change and call up the macro doesn't. I'm getting a "run-time 424 error". I ran this once and it worked but hasn't since. I have the following:
Here's what i've tried:
loaded ms DAO object library
used the "Private Sub Worksheet_Change()" event
Please note the macro to copy/paste/sort is in a module.
Bookmarks