VBA function: Find Average within Dynamic Range

Hi Forum.

I would like to add a custom VBA function to find an average of a range which is defined as follows:

• The selected range is the lower and upper bound for the function
• Within the selected range it should find the first column that is visible (no hidden columns should be taken into account)
• In the function you should add how many rows you want to add into the new Range start. If it exceeds the upper bound defined in the selected range then use upper bound.

I've attached a picture with an example of how i would like the function to behave.

How do i solve that?

Thank you in advance.

3Ce43Zz.png

Here's the function. However, there's no way we can get the formula to auto-refresh when a column is hidden or unhidden. You would have to recalculate the sheet by pressing Shift + F9 or from the 'Formulas' tab.

Please Login or Register  to view this content.