Brian,
As a final check, can you trace through the code on two separate PCs (one which does, and one which doesn't work) and post :
- The line of code.
- The value of each variable referenced in the line of code.
Please ensure everything possible is done to make both versions are as similar as possible.
PS. In case you need assistance with tracing see
Debugging in VBA.