SOLUTION: Sub had to be named "Worksheet_Change" for this to work.
I'm trying to get excel to auto-fill in multiple sheets when one cell in one sheet is updated. I was planning on using the Target.Address function to do this.
However, I can't for the life of me get this to work. I have the following test code in the sheet's code:
I have also tried using
None of which were succesful.
I am working in a Macro Enabled workbook, but excel will never display the message box to me no matter how many times I update B19.
Please let me know of any further information I need to provide, and thank you in advance for any help you can offer.
Bookmarks