Need to return the row value in a table in excel using vba. could be any table any where on sheet ca

This uses the Range's ListObject Property to tell you the column name and row number of the table that the ActiveCell is in. If the ActiveCell isn't in a table you get a message saying so. A row number of 0 means the ActiveCell is in the table's header ro

stackoverflow.com