E
EagleOne@microsoftdiscussiongroups
2003
I know that one is not to be dramatic but this is real deadline!
Please look at my post minutes ago.
The issue seems to boil down to a variable (even though declared Public) is
coming to SubB() empty. In SubA() the variable shows a value in the code
window.
In the same code window, the value in SubB() is blank.
Therefore, no file is opened, and then, "Dim wks as worksheet" fails even
after what I thought was late binding.
See my code previously presented ( 30 or so min ago).
TIA EagleOne
I know that one is not to be dramatic but this is real deadline!
Please look at my post minutes ago.
The issue seems to boil down to a variable (even though declared Public) is
coming to SubB() empty. In SubA() the variable shows a value in the code
window.
In the same code window, the value in SubB() is blank.
Therefore, no file is opened, and then, "Dim wks as worksheet" fails even
after what I thought was late binding.
See my code previously presented ( 30 or so min ago).
TIA EagleOne