Hello!
I've created a macro and I would like to run it easily in each cell from a selection of cells (let's say, for example, 100, 1000, 10000 cells of a certain row or column).
I thought by selecting with the mouse or the keyboard all the cells in which I want to run the macro, and running it, I would get it, but what happens is that the macro is run in the first cell and then, the result of running the macro in that first cell is pasted in the rest of cells, whereas what I would like is the macro run in each one of the cells from the selection (giving as a consequence a different result in each cell). How could I do it?
Thank you very much in advance for all your help.
I've created a macro and I would like to run it easily in each cell from a selection of cells (let's say, for example, 100, 1000, 10000 cells of a certain row or column).
I thought by selecting with the mouse or the keyboard all the cells in which I want to run the macro, and running it, I would get it, but what happens is that the macro is run in the first cell and then, the result of running the macro in that first cell is pasted in the rest of cells, whereas what I would like is the macro run in each one of the cells from the selection (giving as a consequence a different result in each cell). How could I do it?
Thank you very much in advance for all your help.