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