Run Macro when I click on a cell

[Kehjz]

Hi,

New to this, but I have record a simple macro that run on keyboard press.

Is there any way to change it so that the macro will run when I click on eg. Cell A10

Also, I want the macro to select the whole of Column X and Y, but it seems to mess up and select other rows everytime.

Please Login or Register  to view this content.

Thanks in advance!

[haripopuri]

On selection of A10

Copy this code in to Sheet code.

Please Login or Register  to view this content.

For selecting X and Y column, replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

[Kehjz]

For the what I want to do here, I can simply paste the macro inside the area right?

Thanks a lot for the help!


Sent from my iPhone using Tapatalk

[haripopuri]

Sorry, I didn't really give you any code for what you want to do. This code gets activated when you click on A10, that's it. But what you want this code to do is something you have to do decide and write.