worksheet change event

[Av8tordude]

I'm using the code below to change the font colors of cells that have constant values (works well). However, I notice the code triggers a worksheet change event, which I'm puzzled as to why this code triggers a worksheet change event?

Cells(ActiveCell.Row, 20).Resize(, 49).SpecialCells(xlConstants).Font.Color = RGB(14, 33, 56)

 

[Fluff]

Nope, your code does not trigger either a change event or a selection change event for me.

 

[Fluff]

Scrub that, I must have done something wrong last time.
It will trigger the selection change event because you have used SpecialCells.

 

[Av8tordude]

Scrub that, I must have done something wrong last time.
It will trigger the selection change event because you have used SpecialCells.

would you mind elaborating on SpecialCells ?

 

[Av8tordude]

I found information regarding SpecialCells and it seems, this selects the cells, thus triggering selection event.

 

[Fluff]

That's right, it's something I keep forgetting.

 

[Av8tordude]

Ok..Now I can feel better knowing a little than I knew yesterday. thank you for helping me solve this.

 

[Fluff]

Glad we could help.

 

[jasonb75]

edit:- ignore this reply, I didn't see all of the replies and was responding to an older post (last one on page 2)