EXCEL VBA - Find Method or Range in IE throwing error

[Malik]

Hi,

I have 3 users and all are using the same EXCEL Sheet via IE (Same version).
But one of them getting error when excel is trying to find certain items in a
range and assing to a new range.

User 1: Opening an EXCEL Sheet in a separate window and he has no issue.
User 2: Opening same EXCEL Sheet in IE window and has no issue
User 3: Opening same EXCEL sheet in IE window and has an error 'Application
defined ...."

How User 3 can produce an error BUT User 1 can not produce this error.

- During execution User 1 and User 3 leave exiting EXCEL Window and move to
some N window.
- User 2 stick with original EXCEL window and wait for sheet to appear.

Why User 3 is getting error. Please note that:
- All 3 have same data in an EXCEL sheet.
- They are using the same SW/HW configuration

It's only USER 3 using EXCEL sheet differently. Is there any solution for
this error.

 

[JLGWhiz]

It is difficult to tell for sure from what you have described, but my first
guess would be that user 3 has some local settings that are causing the
hiccup.

 

[Barb Reinhardt]

What are the specifics of the error and can you post the code?
Thanks,
Barb Reinhardt

 

[Malik]

Dim oRange as Excel.Range
Dim oFindRange as Excel.Range
Dim FirstAddress as string

Set oRange = <Refer to a certain Range>

' This line is producting error if we leave IE window during processing but
if we stick
' with IE window then there is no error.
Set oFindRange = oRange.Find(2, lookin:=xlValues)
If Not oFindRange Is Nothing Then
firstAddress = oFindRange.Address
Do
Debug.print oFindRange.Value
Set oFindRange = .FindNext(oFindRange)
Loop While Not oFindRange Is Nothing And oFindRange.Address <> f
End With

**** Please ignore if any variable not defined etc. I just tied to clone the
code here
**** There is no problem running this code outside of IE