Macro working only when another cell is selected

[Pauljj]

I have a macro which does everything I want except for a minor issue

The macro starts with this

Private Sub Worksheet_SelectionChange(ByVal Target As range)

Which I know will activate the things I need to once a cell change happenns and this all works fine but at the end of the macro I need it to change something without a cell change happening.

How could I get around this please ?

Please let me know If I need to provide more info

Thank you

 

[yytsunamiyy]

try disabling events:

Private Sub Worksheet_SelectionChange(ByVal Target As range)
application.enableevents = false

'do something to some cell
application.enableevents = true
end sub

 

[Pauljj]

Hi there, that doesn't seem to have made any difference ?