Hi,
I'm really stuck with this one.... I'm trying to have a VBA code that:-
1. will check that the user has selected a certain column (S/N) in a named table (error will be if table1 and/or table1 S/N column is not selected). Col A is no use as there will be more tables underneath table 1
2. Will return the value (in this case a S/N from col A named table1 "S/N", in the form of a msgbox with a msg.
[ATTACH=CONFIG]69365[/ATTACH] The yellow highlight is just for demo purposes!!
referencing the tables a proving difficult....... Any help to get me started would be much appreciated.