defined error

  • Thread starter Thread starter karaisland
  • Start date Start date
K

karaisland

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").ClearContents

Any idea ? Thank you.
 
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").ClearContents

Any idea ? Thank you.
Click to expand...

Hi

Nothing wrong with the statement.

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

regards,
Per
 
If you get undefined variables for vb constants,
replace them with their numeric values.
Click to expand...

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").ClearContents
this is not good

Worksheets("compare1").Range("a2:IV10000").ClearContents
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.
 
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.
Click to expand...

Hi Dave

But I didn't have any problem at all in the first place.
It was like finding your donkey after loosing.
I'd be so pleased if I know what the problem was.

Thanks
 
I've had some problems with .clearcontents when the area contained merged cells.

Any chance?
 
I've had some problems with .clearcontents when the area contained merged cells.
Any chance?
Click to expand...

Hi Dave

Upon further examinations on other files I decided that
I have a problem with letter " i ". Funny but true.
Again on below code same error msg appeared.

With Worksheets("costtabletour3").Range("g2:i1000").Validation

I have twice reinstalled xp' but no avail.
Only few days ago I had no such problem but now I am changing all "i"s
to " I ".

Thanks
 
And if you build a small test workbook and have just enough stuff to be able to
test, does it work ok (with the lowercase i)???
 
And if you build a small test workbook and have just enough stuff to be able to
test, does it work ok (with the lowercase i)???
Click to expand...

Hi Dave
Yes, I have built a fresh test workbook.
Any range addressed with " i " rather than " I " triggers that error
message.
Other letters have no difficulty lowercase or not.

Thanks
 
I've never seen anything like this.

Sorry,

Hi Dave
Yes, I have built a fresh test workbook.
Any range addressed with " i " rather than " I " triggers that error
message.
Other letters have no difficulty lowercase or not.

Thanks
Click to expand...
 
Back
Top