I was hoping someone would be willing to help with taking the prices given in Sheet1 and entering the returns to a new worksheet in the same format. The return formula I'd like to use is
ln(period n+1/ period n); an example would be ln(a3/a2). I realize I could use a formula and drag and drop but I was hoping someone would be willing to write out code that would loop through every cell and then insert into a new worksheet the return for each cell. Ideally I would like the returns to be shifted just to the right of the table in Sheet1, but if it's simpler a new worksheet can be used. The reason I ask is I'd like some help using the structures in VBA which account for varying column and row widths and inserting data using such references.

Stockprices.xlsx