How to extract named ranges for each cell

Hi

I have a sheet which has named ranges for each cell (attached). There are no other named ranges for matrix, only for single cells.

Can I ask how to extract the named ranges and put them alongside? I hope the macro is generic, such that it can automatically search for all cells with named ranges in it.

Thank you.

Can you give an example of what you want your sheet to look like after the code is run? I'm a bit confused as to what you are asking for.

What does "put them alongside?" mean?

Hi davesexcel,

Thank you for the great macro. It worked perfectly.

Thank you, everyone. Very appreciate it. Macro is fun, but not easy. I am learning from your gurus.