I was actually trying to identify the table/cell addresses to replicate the "other" condition in the drop-down that prompts an alert to enter what would be displayed in lieu of the choices in the menu.



I was trying to do it in block 4. to allow for the user to enter a location not in the list.
When I copy the code for "other munitions" I couldn't figure out the table reference.
For the code you did for "othermuntions" it was Set Rng = .Tables(2).Cell(lRow, 2).Range.
I was able to do the next table by copying the code and naming it OtherDemo and changing .Tables(2) to .Tables(3). It worked.
I'm not sure why it would be .Cell(Row,2) though... it's actually row 3.

But when I do that for the table above munitions I'm assuming it's .Table(1) but I can't identify the row or cell for 4. LOCATIONS.