Excel -- changing named range triggers function

[avandale]

Hi,

I have a named range on a spreadsheet, listing employee names. When any changes are made to cells within this range (A single column with 150 rows), it triggers a sub procedure that has no relation to it. I know of the worksheet_change event, but don't have one associated with this workbook.

Does anyone know what could be causing this?

Many Thanks

 

[SkipVought]

Hi,

Here are several places to look.

In the Worksheet object change event

In the Workbook object in the SheetChange event

In the VB editor Tools/References some addin or other workbook that is referenced



Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884