AS AN EXAMPLE, USE THE COLUMN LISTED BELOW
Trying to record a macro to obtain an average of the column. the cursor would be located at cell a20.
The range above is a15:a19
The macro must be adaptable because the next sheet would have a different range