i want to write a function that automatically fills other cells so i can
have a dynamic design.
here is my testfunction, if you tell me what to do to make it work, i can do
the rest alone:

public function test(text as string) as string
Cells(1, 2).value = "it works"
test = text
end function

thanks for your help
bommel