refer from worksheet_change event to workbook named range

[jaryszek]

Hi Guys,

i am on worksheet_change event and i want to refer to workbook scope named range but there is an error:

Screenshot_7.png

how can i do this?

Best,
Jacek

[romperstomper]

A workbook doesn't have a Range property. Use Application.Range instead, or Activeworkbook.names("S_protectworkbook").referstorange.value

[jaryszek]

ok thank you!