Run Macro when a cell within a range changes

M

Mik

I have a range of cells ("d4:d20").
The values of these cells can change depending on other aspects of the
spreadsheet.

When 'any' of the cells within the range ("d4:d20") change, i wish to
copy & paste the range to ("e4:e20").

I have searched the groups etc. and tried many different codes, but
had no luck so far.
Could anybody please assist?
 
S

stanleydgromjr

Mik,

How are the cells in range "D4:D20" changing: manually, or by
formula?


Have a great day,
Stan
 
M

Mik

Mik,

How are the cells in range "D4:D20" changing:  manually, or by
formula?

Have a great day,
Stan
Click to expand...


Hello,

The cells are changing by fomula in this case.

Thanks
 
S

stanleydgromjr

Mik,

We may be able to use the "Worksheet_Calculate" Event to trigger the
copy of the range.

What are the 17 cells (D4:D20) returning: numerical values, strings?

Please post the formula in cell D4.


Or, please post your workbook (or sample) - scroll down and see "Manage
Attachments".


Have a great day,
Stan
 
Top