Of a virus problem I had to reinstall my windows xp and office xp.
And I faced this highlighted error
" Application defined or object defined error "
No need to add this was a smoothly working vba code before.

Worksheets("compare1").Range("a2:iv10000").ClearCo ntents

Any idea ? Thank you.

On 31 Maj, 21:45, wrote:
Of a virus problem I had to reinstall my windows xp and office xp.
And I faced this highlighted error
" Application defined or object defined error "
No need to add this was a smoothly working vba code before.

Worksheets("compare1").Range("a2:iv10000").ClearCo ntents

Any idea ? Thank you.

Hi

Nothing wrong with the statement.

Does the worksheet "compare1" exists in the active workbook?

regards,
Per

Yes Per, it exists.

Thank you

In the VBA editor, select Tools, References. If you have a reference to the
Microsoft Office Object Library, uncheck it if you can. Then see if the
module will compile. If you get undefined variables for vb constants,
replace them with their numeric values.

Robert Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

wrote in message
...
Of a virus problem I had to reinstall my windows xp and office xp.
And I faced this highlighted error
" Application defined or object defined error "
No need to add this was a smoothly working vba code before.

Worksheets("compare1").Range("a2:iv10000").ClearCo ntents

Any idea ? Thank you.

If you get undefined variables for vb constants,
replace them with their numeric values.

Thank you Bob.
That is exactly what happened. How disturbing it is.
But why I never had such error before i don't understand.

It is most likely due to a flaw in an SP upgrade from Microsoft.

Bob

wrote in message
...
If you get undefined variables for vb constants,
replace them with their numeric values.

Thank you Bob.
That is exactly what happened. How disturbing it is.
But why I never had such error before i don't understand.

Worksheets("compare1").Range("a2:iv10000").ClearCo ntents
this is not good

Worksheets("compare1").Range("a2:IV10000").ClearCo ntents
this is good

Took my 2 days to find out a solution to
" Application defined or object defined error " . God !

Your problem may have gone away, but this was not the solution.

VBA doesn't care if your range address was in upper/lower/mixed case.

wrote:

Worksheets("compare1").Range("a2:iv10000").ClearCo ntents
this is not good

Worksheets("compare1").Range("a2:IV10000").ClearCo ntents
this is good

Took my 2 days to find out a solution to
" Application defined or object defined error " . God !

--

Dave Peterson