Limit a macro to only run when certain cells are selected

[lptubez]

I have a code for a department calendar so when you select a week number and click a button, it autofills the schedule for the week. It works great and my boss loves it, but because it uses relative referencing, it will create little autofill disasters if the wrong cell is selected.

I'm looking for a code that will limit it to only work when specific cells are selected:

(B4, B15, B26, B37, B48, B59, B70, B81, B92, B103, B114, B125, B136, B147, B158, B169, B180, B191, B202, B213, B224, B235, B246, B257, B268, B279, B290, B301, B312, B323, B334, B345, B356, B367, B378, B389, B400, B411, B422, B433, B444, B455, B466, B477, B488, B499, B510, B521, B532, B543, B554, B565, B576)

Here's the code I have now:

Please Login or Register  to view this content.

I found an earlier thread with a similar problem, but not quite close enough for my simple mind to connect the dots:
http://www.excelforum.com/excel-prog...-selected.html

Thanks in advance for any help you awesome people can give.

[mehmetcik]

try this instead:

Please Login or Register  to view this content.

[mehmetcik]

Or you could try this:

Please Login or Register  to view this content.

[lptubez]

Works perfectly, thank you!

I'm wondering, what would the code to specify a range of cells look like?

[mehmetcik]

You could modify my second code above or

use the intersect function if you have a range.

Please Login or Register  to view this content.

[lptubez]

Thank you again!

[QUOTE=mehmetcik;3918539]You could modify my second code above or

use the intersect function if you have a range.QUOTE]

[lptubez]

Thanks again! I wasn't very clear. This is for a different macro in the same workbook and I'm having trouble adapting the code to it. I am very new to this, and thought that if I could see how to do it once I would be able to figure it out, but apparently not!

If you can show me how to make the following macro run only if a cell in D6:H15 or D19:H28 is selected, I think I can figure it out from there.

Please Login or Register  to view this content.

You could modify my second code above or

use the intersect function if you have a range.