Copy a range from one worksheet into another

I am trying to copy a range from one worksheet into another. The range selected to be copied is based on criteria selected.

Example: if an "x" is placed in any of the following cells (C24,C25,C26,C27,C28) on the operational tab then copy range ("K29:N29") from the Operational tab to ("B28:E28") on the Summary tab

I have written it as a CASE statement but it keeps failing.

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

Thank you for your response.

I wanted to use a case statement becasue I need to be able to repeat this several times meaning if the "x" is in another range a different range will need to be copied.

Maybe:

Please Login or Register  to view this content.

John Thank you it work I am most greatful.

Can you explain what Intersect does I am not sure I understand.

You're welcome. Glad to help out. Intersect returns a Range object the represents an intersection of two or more ranges. In this case Target is a Range and Range("C24:C28") is a Range. Therefore when the target cell is within Range("C24:C28") (ie intersect) it sets off the event or the actions you want the macro to perform.