I have 2 Defined Names ("Animal" & "Names") reflecting cells in columns "B" and "F". If I have empty cells at the end and I add new data after the empty cells the Defined Names ranges does not reflect the data after the blank cells.
Is there a way to refresh and update dynamically the Defined Names in excel VBA
Attached is the worksheet.
Thanks