How to run a macro on different cells?

**areli** · 06-12-2012, 06:01 PM

Is there a way to click on a cell then click a button with an assign macro that would clear the contents in the corresponding row for the cell that was clicked? I want the same button to clear the contents in the row every time a cell is clicked followed by the click of the button.

Thank you,
Areli

**TMS** · 06-12-2012, 06:16 PM

Please Login or Register  to view this content.

Regards, TMS

**TMS** · 06-12-2012, 07:03 PM

Thanks for the rep. Solved?

**areli** · 06-13-2012, 11:52 AM

Yes thank you very much. Now I want to tweak it a little, instead of clearing the entire row, I want to clear only some of the cells in that corresponding row. How can I go about that?

**TMS** · 06-13-2012, 12:03 PM

Which columns?

**areli** · 06-13-2012, 12:11 PM

Column F,N,O and P

**TMS** · 06-13-2012, 02:00 PM

Please Login or Register  to view this content.

Regards, TMS

**areli** · 06-13-2012, 04:32 PM

That works! But can you please explain me a little of how the code works?

Thank you soo much for your help.

**areli** · 06-13-2012, 04:52 PM

Also, after running the macro, the cells that were cleared stay highlighted. How do I go back to the original active cell?

**TMS** · 06-13-2012, 05:05 PM

The cells are never selected, just cleared ... so I don't know why that is happening for you.

The Active Cell is not changed.

The code determines the row number of the active cell. It then uses that with the column letters to clear the cells.

If more than one cell is selected, the code will only clear the first row cells.