Partial Update?

A

Andy Chan

Dear all,

There are two range of cells A1:A10 and B1:C10 in my workbook. I want
the content of A1:A10 to be updated automatically when some contents of
B1:C10 is modified. How should I write a macro for it?

I understand that I can just let my workbook update every cell whenever
there is some change. However, as there are thousands of complicated
formulae in the workbook, I would like to suppress the automatic update
function but only update A1:A10 when B1:C10 is updated. Can it be done?
Thanks in advance.

Best Regards,
Andy
 
B

Bob Umlas

right-click the sheet tab, select View Code, enter this:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("B1:C10")) Is Nothing Then Exit Sub
'put your A1:A10 changes here.
'put your A1:A10 changes here.
'put your A1:A10 changes here.
'put your A1:A10 changes here.
End Sub
Bob Umlas
Excel MVP
 
Top