Thread: Compare named ranges
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Ivan Raiminius
 
Posts: n/a
Default Compare named ranges
Hi,

you may use:

Private Sub Worksheet_Change(ByVal Target As Range)

Target is the range that have changed, see help for more details

Regards,
Ivan

Reply With QuoteReply With Quote