Use cell value to adjust date range

[GoBucks]

I have a range (M6:BM6) which consists of week end dates = every Friday (M6 =
5/8/09; BM=5/7/10). I would like to have the range adjusted based on when a
cell (B3) is updated. For example, currently B3=5/5/09 and M6=5/8/09 (week
end date of B3). If B3 was updated to 5/12, I would like to have the range
automatically updated to M6=5/15/09, N6=5/22/09....BM=5/14/10. I could do
this with excel formulas in the sheet but would like to macro code adjust the
values in the range rather than formulas.

Any suggestions?? Could this be accomplished by a Worksheet Event?

 

[royUK]

There's no point using VBA if formulas will do the job. Apart from the
fact that the formulas should be simpler, using macros means that the
user must enable macros, not always the case.

 

[GoBucks]

I totally understand but the date ranges are used in other macros and those
work much better with values rather than formulas. Otherwise, I wouldn't
attempt to use VBA.