Run a macro when cell selected in every nth column

[gopal baheti]

My data Lies between A5:AZ1500
what i need is:
Run Macro1 when cell selected lies in A5:A1500, D5:D1500, G5:G1500........ every fourth column
Run Macro2 when cell selected lies in B5:B1500, E5:E1500, H5:H1500........ every fourth column
Run Macro3 when cell selected lies in C5:C1500, F5:F1500, I5:I1500........ every fourth column

Thanks.

[JBeaucaire]

That's actually every 3rd column... In the sheet module, something like this:

Please Login or Register  to view this content.