Search results for query: *

That did it. Thank you so much for your help!

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

I'd love to, but, like I said, it works fine as a sub routine..Can you step through a function?? If not, I don't know what else to do... Thanks.

Thanks, but this still returns #VALUE! when I execute the function...anyone know why? I assume variable mismatching, or something is going on...

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