MadMamaKat
New Member
- Joined
- Sep 30, 2018
- Messages
- 1
Hi Folks,
I am assessing the values of several thousand data sheets. So far, I am running a macro to conditionally highlight cells of specific values, then writing down the table location. I am trying to expedite the process by getting Excel to list the cell names for me. I named each cell based on it's table (it's a range, not a real table) address (so cell B5 is named A_1). I thought maybe:
IF(B5:AW36=0, "A_1:AF_48, "") but that did not work.
I can't seem to attach anything here.
Thank you!
I am assessing the values of several thousand data sheets. So far, I am running a macro to conditionally highlight cells of specific values, then writing down the table location. I am trying to expedite the process by getting Excel to list the cell names for me. I named each cell based on it's table (it's a range, not a real table) address (so cell B5 is named A_1). I thought maybe:
IF(B5:AW36=0, "A_1:AF_48, "") but that did not work.
I can't seem to attach anything here.
Thank you!
Last edited by a moderator:
