Hello,
I just managed making my first VBA function.
The function was tested in step-by-step mode and works OK
but when I call it from an actual spreadsheet is does
only part of the work.
The function does a lookup on another spreadsheet using
Vlookup, then returns the value of the row where the
match was found, copies the same row and should paste
this row on my active worksheet right from the active
cell. In step-by-step mode the function does everything
including the pasting part, but when I call the function
it will correctly return the value of the lookup row, but
will not do any pasting.
Any help is greatly appreciated.

Roel