Hello everyone. New to the forum AND to Excel macros. Be gentle!
I need to use a macro for this as it is called by another program (Macro Express). ME opens a workbook and finds the first available blank cell in column A. I need to have my macro produce an index by comparing cell by cell changes in all the values above the blank cell. My first thoughts are to divide A1 by A2. If the result is 1, then my index is unchanged. If the result is >1 then the index will be -1. If it's less than one then the index will be +1. This enables me to roughly ennumerate a trend as a numerical value that the original ME macro can use in its decisions.
For example

115
115
115
125
125
125
125
105
105
BLANK Will result in a "0" index

115
115
115
116
116
119
119
BLANK Would result in an index of "2"

Would really welcome any suggestions of how to approach this problem.