Run Macro on cell update in range (Cant figure it out)

**ofirio** · 11-29-2012, 11:46 PM

Hello,

Sorry to post this question, I know it gets asked a lot. I have searched a lot and have not been able to find a working code for what I am trying to do.

I need to run this macro anytime a cell within the range gets modified. Here is the macro I need to run:

Please Login or Register  to view this content.

Any help would be greatly appreciated.

**NickyC** · 11-29-2012, 11:56 PM

Hi
can i suggest you edit your post and put code tabs around your macro code - or a moderator might ping you!

Right click the sheet you want to edit and try this code - you wil need to set the range you want

Please Login or Register  to view this content.

**ofirio** · 11-30-2012, 12:03 AM

Thanks for the quick response and the tip about the code tab. New around here.

I entered this code:

Please Login or Register  to view this content.

And it is working for any new value entered. The only problem I have now is that it does not run the macro if I change the cell from bold to unbold. Is there any way to include that action as a trigger?

Thanks