Apply VBA code to multiple cells

Hi,

I've been using this forum for quiet a while now, and I can usually find an answer without posting my own question, but I really need help on this one.

I have a spreadsheet which I made to use as a to-do list, I have a date requested column which I want to automatically put in today's date when I select the cell, which I can get working by using the following code:

Please Login or Register  to view this content.

I need to find a way to apply this to cells D6 to D52.

I was just going to enter the code several times and change the cell reference, but this returns an error.

I hope I've offered a good enough explanation for someone to help me, if you need any more information let me know.

Any helps greatly appreciated!

Fantastic!
Works brilliantly
Thanks alot!