Hey all,

I am after a macro command that when the button is pressed, all other cells with the same text (within the sheet) as the target cell appear blank.

I am intending to use this as a tool for my timetable when selecting my tutes, so when i select the tute i want to go to on my timetable, all the other tutes on screen appear empty.

This also needs to be reversible. I have a very basic knowledge of VBA. very very basic...

cheers