I understand you cant have two Workbook_SheetChange events in your YourWorkbook - but i need the macros to run throughout each sheet.
Here are my two.....can they be merged (they do very different things)?
Please Login or Register to view this content.Please Login or Register to view this content.
Why not use the event macro to call the macro from a standard module?
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
please explain?! i am a noob.
Post a sample workbook, It will be easier to modify the code than explain it. Then you can play with the code to see how it works.
Activity test.xlsm
See new code in YOURWORKBOOK, this wont run as I have a change event already...
I don't understand what you are trying to do?
I want the event to fire off my current event macro that effectively sorts by column c. My second event that is clashing simply changes one cell based on the value of another
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks