I want to get the row number of the first visible row on one of my sheets. So for example if rows 1 - 499 were hidden then I want to write a formula that returns the numerical value 500.
I know this will probably require the usage of the ROW
function but I'm not sure how to write the required condition.