Excel 2010 x32 on Windows 7 x64
VBA complies fine. References are three ActiveX 6.0, and the usual suspects.
Beginning of Subroutine
Sub ImportHC()
On Error GoTo Err_ImportHC
Debug.Print Range("DEPT")
wbOrg = Range("DEPT").Value
wbOrg = Left(wbOrg, 4)
Debug.Print wbOrg
............ End Sub
sometimes the Debug.Print Range("DEPT") throws the error "1004 Application-defined or object-defined error"
sometimes it doesn't.
sometimes the code works stepping through using F8
sometimes it doesn't
Hasn't work in full execution mode.
What am i missing?
Thanks in advance
sportsguy
Bookmarks