Need Help - Small fix required

[arjunmca]

Hi,
I wrote the below code to clear 'B5' cell value.

Worksheets("Sheet1").Range("B5")=""

Its working fine in Win 2000. But in Excel 2007 it is giving the following error on VISTA OS.

Run-time error '-2147417848 (80010108)':
Method 'Value' of object 'Range' failed

Can any body fix that error.
-Arjun.

 

[silkfire]

It should be:

Worksheets("Sheet1").Range("B5").Value=""

 

[lenze]

Why not?

[B5].ClearContents or
Range("B5").ClearContents

lenze

 

[arjunmca]

Hi,

Thanks for your reply.

(1) Worksheets("Sheet1").Range("B5").value=""

Still the same error coming.

(2). Worksheets("Sheet1").Range("B5").clearcontents

Cell is not clearing the contents. The value remains in the B5 cell.
Do we need to use screen updation.
I even tried with Application.ScreenUpdating=True.

But it is not clearing the cell.

Please try to fix this error.

 

[lenze]

Don't know what's happening, but

Sub Fanugi()
Sheets("Sheet1").Range("$B$5").ClearContents
End Sub

works, as does

Sub Fanugi2()
[B5].ClearContents
End Sub

lenze

 

[arjunmca]

Hi,

I tried as you replied. But still getting the same error in 2007 office in Vista OS.

Sheets("Sheet1").Range("$B$5").ClearContents
[B5].ClearContents


Can you please confirm that after the testing the code in 2007 office in Vista system.

Regards,
Arjun.

 

[lenze]

Is you worksheet protected??
lenze