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.

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
on cell with function. then click on formula box on top of worksheet (fx).
Press enter which makes excel thingks the cell is changing.

"hmm" wrote:

> 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.

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)

"hmm" <(E-Mail Removed)> wrote in message
news:5ADC2AB1-A1F7-4599-AD46-(E-Mail Removed)...
>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.

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

"Joel" wrote:

> 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
> on cell with function. then click on formula box on top of worksheet (fx).
> Press enter which makes excel thingks the cell is changing.
>
> "hmm" wrote:
>
> > 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.

Thanks Bob. Also works like a charm.

"Bob Phillips" wrote:

> 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)
>
> "hmm" <(E-Mail Removed)> wrote in message
> news:5ADC2AB1-A1F7-4599-AD46-(E-Mail Removed)...
> >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.
>
>
>