UDF programming... PLEASE HELP!!!
Thank you!
Anna
"Randy Harmelink" wrote:
anna wrote:
' 2. Named reference NB = number of blades in 360 deg ring.
If HI = 0 Or HI = NB Then
If NB is a named reference, I think that latter statement needs to be
something like:
If HI = 0 Or HI = Range("NB")
....or:
If HI = 0 Or HI = Worksheets(cond).Range("NB")
....depending on how you need to reference it. Why not just pass it as
a parameter to the function as well, rather than assume it's going to
be available?
|