how do i declare a global variable in VBA
- by Nimrod
I wrote the following section:
Function find_results_idle()
Public iRaw As Integer
Public iColumn As Integer
iRaw = 1
iColumn = 1
and i get the error messege:
"invalid attribute in Sub or Function"
do you know what i did wrong?
i tried instead of "Public" to use "Global" but got the same problem.
I tird to declare the function itself as "Public" but no good...
what do i do wrong?
thanks.