Can you overload functions in VBA? I thought you could but I'm getting the ambiguous name error. I have two functions:
Function FindTableSheet(strTableName as String) as String
' code here
End Function
Function FindTableSheet (strTableName as String, ByRef strShName as String) as boolean
' code here
End function
I'm typing this in on a tablet so I may have missed typed something there. Both functions search active workbook sheets for the given strTableName. The first function returns the sheet name if it finds a table by the name in strTableName. The second one does the same but returns true if if find the table and false if it doesn't. Set strShName to the Sheet.name on success or vbNullChar on failure.
Maybe I have my languages mixed up but I thought this was legal. Thanks. Chunk.