Thread: Need to hide all rows except what is currently selected or is empty

It has been years since I've used Excel macros and am more than rusty, so would appreciate help with this.

I would like a macro to hide all rows except what is empty or what is in the current cell when I run the macro.

So in column C, I have values like AFA, PCPR, PR, AFAE, AFAC, SC, CR, etc. (this group of values will grow) which repeat in column C througout the spreadsheet numerous times.
Column C also has some empty cells which I would always like to remain visible.

e.g.
Column C
AFA
PCPR
[empty]
PR
AFAE
AFAC
PCPR
SC
CR
AFA
PCPR
[empty]
SC
CR

Highlight PCPR and run macro

Column C RESULTS:
PCPR
[empty]
PCPR
PCPR
[empty]


Thanks for your help