Run Macro when a cell within a range changes
 

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?

Run Macro when a cell within a range changes
 

Mik,

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


Have a great day,
Stan


--
stanleydgromjr
------------------------------------------------------------------------
stanleydgromjr's Profile: http://www.thecodecage.com/forumz/member.php?userid=503
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=117561

Run Macro when a cell within a range changes
 

On 19 July, 22:40, stanleydgromjr <stanleydgromjr.
wrote:
Mik,

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

Have a great day,
Stan

--
stanleydgromjr
------------------------------------------------------------------------
stanleydgromjr's Profile:http://www.thecodecage.com/forumz/member.php?userid=503
View this thread:http://www.thecodecage.com/forumz/sh...d.php?t=117561


Hello,

The cells are changing by fomula in this case.

Thanks

Run Macro when a cell within a range changes
 

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


--
stanleydgromjr
------------------------------------------------------------------------
stanleydgromjr's Profile: http://www.thecodecage.com/forumz/member.php?userid=503
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=117561