The attached workbook does what you describe. It uses the Worksheet_Change
event for Sheet 1 to capture changes in the target column. I substituted
your "Gold" and "Silver" routines with a Print for testing. Uncomment and
add whatever modification routine you need. If you have any questions let
On 11/17/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> I'm trying to create a macro that will do the following:
>
> When the user changes a value or values in column 'B', the macro will
> iterate through all cells in columns 'C' to 'AO' but only in the same
> row(s) that were changed in col
