Thanks for the responses...I've narrowed the issue down to one line of code:
Loop While Not c Is Nothing And c.Address <> firstaddress
This works fine in the subrountine but kicks out in the UDF. I believe the reason is the line above it:
Set c = .FindNext(c)
This seems to fail in the...
Hi! I wrote the sub below, which works, (it's a 3D SumIf) but when I make it a function it just returns VALUE#! Can someone tell me what I'm doing wrong?
Thanks!
-----------------------------------------------------------
Sub sumifall()
Dim Look_Val As String, Tble_Array As String, Sum_Range As...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.