Run Macro on Highlighted Cells

Hey all,

I think this should be relatively simple. I want to have a macro that inputs the date into ONLY the highlighted cells. I easily found how to input the date using:

Range("A").Value = Date

However I have been unable to find how to only apply this to the highlighted cells. Any help is appreciated.

Also, is it possible to create another macro that would input todays date plus three business days? That would surely be more difficult, but I am curious if that is an option. Thanks.

Originally Posted by TMShucks

Try:

Selection.Value = Date

and

Selection.Value = Date+3

Regards

Scratch that on the difficult part. Thanks for the help, this is nearly exactly what I need.

Does anyone else know if there is a way to exclude weekends in the "Date + 3" calculation to only make it business days. Thanks!