Dropped Values

[rfwooodvt]

Hi! I'm running a macro that has several parameters being passed

My cell reads like this

=DoWho(A1,c1,f1,g1,k1,L1)

When I use the pulldown to fill in the variables with cell references it shows the values of each parameter cell I reference.

Problem is that once in the function, some of the parameters come in as null
If I throw a stop into the function and place my cursor over the parameter names YesterdayShares alwasy shows the passed value and YesterdaysAction is usually correct, but lowTrig,HighTrig,TodHigh and TodLow will often be empty or 0, even though the data is in the referred cells and when I click on the function helper I see the data on the right side of the screen.

any help is appreciated!


Function DoWho(YesterdayShares, YesterdaysAction, LowTrig,HighTrig,TodHigh, TodLow)

DoWho = ""

If YesterdayShares > 0 And TodLow < LowTrig Then
DoWho = "CoverLong"
GoTo endDh
End If

If YesterdayShares < 0 And TodHigh > HighTrig Then
DoWho = "CoverShort"
GoTo endDh
End If

endDh:
End Function

[royUK]

Please use Code Tags when posting code - see Item #2 of the Rules

http://www.excelforum.com/showthread.php?t=591596

Why not use an nested IF Function instead of a UDF?

[rfwooodvt]

sorry about the wrapping, I looked at rule two and didn't see anything that referenced "Wrapping"...and I actually am a neophyte at this.

Not sure what you mean by using the "If"

I suppose too that I mis-used the workd macro. Basically I have a worksheet populated with data from a Access file and on each row there is a cell that calls the function I mentioned. Works like any other function in that I pass parameters and expect a value to be returned.

Again, the problem is that even tho there is data in the cells that are referred to when it drops into the function some of those values are not there. I'd like to know why and how to fix it.

Thoughts?