private function repeating

Hello,
I have a private function which works well.What I am trying to do after the formula has run is to copy and paste values into the next column.What is happening then is every time I try to copy and paste into this next column the formula starts working again calculating the cells.It eventually finishes and the column is filled with only the values.The problem is why is this happening and how do I stop it from recalculating when I try to copy and paste into the next column.As there is a limit on the number of entries I can download using this function by having the function start calculating again means that I run out of opportunities and the original data then changes to #Value.Hoping someone knows what is going on and may be able to assist me please.

functions should never take actions such as here you explain copy / paste data

Correctly (IMO only) the function should pass a result and that result acted on ie

one code procedure Sub and one Function

that way its easier to maintain and parse

post the code so we can have a look

Hello,
I realised I should have stated that after the first entry I then use this

Please Login or Register  to view this content.

to continue the formula down the column as the
length of the column varies each day .

duplicate entry