Thread: Delete method of Range class failed
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dan_coder dan_coder is offline
external usenet poster
  
Posts: 1
Default Delete method of Range class failed

Hi guys

I have a program written in VB.Net that manipulate an XLS file usin
VBA. I have to delete some lines:

ows.Range("119.190").Delete("Shift:=" & -4162)

-4162 is the real value of xlUp

It raise me this exeption:

Delete method of Range class failed

Previously, I tried this:

ows.Select("119.190")
oEx.selection").Delete("Shift:=" & -4162)

The problem persist.

Any idea?

Thank you in advance

--
dan_code
-----------------------------------------------------------------------
dan_coder's Profile: http://www.excelforum.com/member.php...fo&userid=3668
View this thread: http://www.excelforum.com/showthread.php?threadid=56418

Reply With QuoteReply With Quote