How to copy and paste Macro with different ranges?

[SMIengineering]

Hi guys. i am working on my offices inventory spreadsheet. We have to log in and out materials that are kept in a freezer. i have set up the following macro so that users can double click to insert the Tim stamp
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Intersect(Target, Range("timestamp")) Is Nothing Then Exit Sub
Target = Now
Cancel = True
End Sub

My problem is, i want to apply this macro to B11:U12, B17:U18, B23:U24 and so on for about 1000 rows. I have labeld B11:U12 as "timestamp" (not important to be named). how can my macro do this to all proceeding ranges?

Example worksheet upon request

[xladept]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[SMIengineering]

When I try to add a Macro to second group it gives me an error message. I tried to give you a before and after but i ran into this problem. I am new to Macros so i Apologize if i am missing something obvious. I would like to be able to copy and paste more down the list when needed without building the double click macro for each if possible. thank you
Example.JPG

[jindon]

Try

Please Login or Register  to view this content.

[SMIengineering]

Thank you!! that worked! You are a hero