Debugging a function

[Guest]

I have used the debugger to go step by step through a subroutine, but I have
not succeeded in doing so for a function. I suspect this is because the
function does not know where to call its argument values from.

Is there any way to include the arguments in cells, or call the function
from a cell, and then step through with the debugger? Any insights
appreciated.

 

[Guest]

I do it one of two ways

1) create a subroutine test with no parameters. the call the function from
Test

sub Test()

set myrange = Range("A1:B22")
call myfunction(myrange)

end sub

function myfunction(target as range)


end function

2) Put break on first line of function. Then code to spreadsheet and click

 

[Bob Phillips]

Call it from the immediate window and pass the parameters, like so

?myFunction(num1,"text2")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Thanks Joel. I used the second option you gave and it works great.

 

[Guest]

Thanks Bob. Also works like a charm.

Call it from the immediate window and pass the parameters, like so

?myFunction(num1,"text2")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)