passed function argument not arriving to function?

[RAYLWARD102]

I have a function I wrote years ago.
I'm not sure why, but sometimes, the string sent, is arriving empty to the function; not sure how this can be happening.
This is very strange.

Function FrameLoad102(ByVal MyQuery As String)
    MsgBox MyQuery
End Function


'function call method
FrameLoad102 "SELECT TOP 75 * FROM landscape.dbo.allocate WHERE deleted = 0 ORDER BY ID DESC"

 

[RAYLWARD102]

What I failed to mention, is how the "select top 75...." was stored in a variant. Never had this problem before, but seeing strange things happening with excel vba where a variable isn't storing.
Example:

'the memkeep variable is declared in my Module1 declarations as 'Public memkeep as Variant'

ReDim memkeep(0 To 6, 0 To 1)
memkeep(5, 0) = 1

when debugging, no error are thrown, but can see memkeep(5,0) = empty (very unusual)
Was there some recent updates that have screwed vba? Happening on all of our computers, running office 365 enterprise, fully updated.