Use cell value to adjust date range

G

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?
 
R

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.
 
G

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top