Why do I have to create a new sub?

[bjcowen9000]

Why when I put the following code does it ask me to create a sub name? And can someone help me so that it doesnt? I just want to paste then into module, click play, and it works without making me open another sub

Please Login or Register  to view this content.

[Norie]

What exactly do you mean, I've never been asked by VBA to create a new sub.

Where are you pasting the code?

By the way, are you sure you want this code to run every time the selection is changed to select something in the range X:AI?

[AlphaFrog]

Do you already have a Worksheet_SelectionChange procedure? You can only have one procedure like this for a given worksheet.

If you had two, you could combine their code between the start and end of one procedure

Please Login or Register  to view this content.