How do you make VBA perform a macro on EACH activecell highlighted?

[kjy1989]

So for example, I have a code that enters certain data beside the active cell.

Please Login or Register  to view this content.

But what if the user highlights range A1 to A5, I want to make it so that my following code will apply to the entire range. Is that possible?

or maybe if the user uses CONTROL+CLICK and jump and highlight non contiguous cells like Range A1 and Range A12 and he runs the macro, i want my code to apply on Range A1 and Range A12, is that possible?

[millz]

Please Login or Register  to view this content.