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.

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.

"Malik" wrote:

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.

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



"Malik" wrote:

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.

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
--
Malik


"Malik" wrote:

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.