Hi all,

First post, hopefully it will be an easy one for you lot.

I have created a vba user defined function which performs a calculation. I would like to copy the end result of the calculation in the function to be copied to a cell that is two rows down from the cell which performs the function. I don't think this is possible but thought I would ask the question anyways.

I have enclosed a document, the function in the vb is labelled as copypaste and I would like to paste the copypaste value which is 2, from the activecell to two rows below. This should work exactly the same should I put the function into any other cell.

Appreciate your feedback.

JaysonCopypastefromfunction.xlsm