Copy and pasting from a user defined function.

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

Didn't think so!! I require part of the calculation in the function to be copy and pasted into a spreadsheet together with the end result of the function, so we can see one part of the calculation as a value. The alternative is to break the function up into the calculations I require, however I was hoping I could get this all in one function.

Many thanks for your response.

How do I do that?

Thanks for this I will give it a try!!