Macro starts on clicking only certain column cells

Hi all,

I have it set up on a sheet for a macro to start whenever a cell is clicked, but I'm trying to figure out how to narrow that down to only certain column cells being clicked.

You can see the current code below... and it just basically activates the AddToCell macro once any cell is clicked. The problem with this is, it errors on cells with text in them and no longer lets me edit the sheet without disabling the macros and so on. So, instead of it activating on all cells, I'd like to find a way to have it just work for columns E-I.

Any help would be appreciated.

Thanks much

Please Login or Register  to view this content.

I'm an extreme novice when it comes to messing with VBA... can you explain to me a little more in depth how to do this with the module and everything?

Thanks for your help

OK.. almost there.. the only issue I've run into now is that the macro doesn't seem to work on pre-existing figures. The idea is that there is a number already in the cell and I can click it, type in a number and it will add to the previous one. It works on blank cells, but the ones that have something in them currently don't seem to run the macro.

Thanks for your help

Oops... sorry about that... it works perfect now, thanks very much for your help