Hi:
I’m trying to pass variables to a script library. The variable in question is a string and has been declared as such when the library is called from a button. I’m trying to pass the value to a sub using:
Call setcolumnheadings(object, key)
I’m declaring it at the beginning of thenext sub like this:
Sub setcolumnheadings(sheet As Variant, key As String)
When I run it through the debugger I can see the value of key, and see that it’s set as a string and yet I still get a Mismatch on it. Why?
Any suggestions on how this can be fixed would be appreciated.
Thanks