Excel VBA Archives - Page 2 of 2 - Excelguru

Function findContent()

Byketil 21. July 202012. September 2021

Find content in column1 with header xx, return value from same row in column2 with header yy. Note The function returns 0 (Zero) when value isn’t found, so you will not be able to distinguish between a found zero value, and value not found. So do not use if you have zero values in your…

My Common library

Function ffR() – Find First Free Row

Byketil 20. July 20208. September 2021

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 contiguous range from a spesific cell. The contiguous range is the range from A1 in the case below – with no empty rows. Selecting CurrentRegion…