View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SaltyBall SaltyBall is offline
external usenet poster
 
Posts: 5
Default Worksheet_Calculate() , How to find affected cells?

Hi,

Worksheet_Calculate(), I want to make cells change color when its value
change after recalculate.

Worksheet_Change() can use "Target.address" to locate the changed cells

How to find affected cells for Worksheet_Calculate()?
Worksheet_Calculate() have no "Target.address"


Thank you.