English – Excel Visual Basic for Applications

When I want to add a new record to a table, I use the function CurrentRegion.Rows.Count and add 1 to the result to find the first empty row.CurrentRegion returns the…

Find content in column1 with header xx, return value from same row in column2 with header yy.