Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: JCrin
  • Order by date
  1. JCrin

    converting sub routine to function in excel

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

    converting sub routine to function in excel

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

    converting sub routine to function in excel

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

    converting sub routine to function in excel

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

    converting sub routine to function in excel

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

Part and Inventory Search

Back
Top