Solved

late Binding command to delete a cell in excel using VB2005

Posted on 2008-06-11
5
237 Views
Last Modified: 2012-06-27
Hi,

IM using Vb2005 and late binding to do some stuff in a spread sheet.

I want to delete a cell and push all cells bellow it up, I have been using a delete the whole row code but that is not acceptable any more.
  objSheetsH.Rows(4).Delete()

I'd appreciate any help on this.

Thanks Michal
0
Comment
Question by:MichMat
  • 3
  • 2
5 Comments
 
LVL 48

Expert Comment

by:jpaulino
ID: 21764563
Hi MichMat,

Try:

objSheetsH.Rows(4).Delete(-4162)
0
 

Author Comment

by:MichMat
ID: 21764582
Hi

Sorry, I probably didnt explain my self right the code to delete row works but I dont want to use it I want to delete cell F4 ONLY  

Michal
0
 
LVL 48

Accepted Solution

by:
jpaulino earned 500 total points
ID: 21764596
Ok, try this:

objSheetsH.Range("F4").Delete
0
 

Author Closing Comment

by:MichMat
ID: 31466382
I was expecting a more complicated answer for the solution of the problem ....... ahh well I'll just have to take the simple one :)
0
 
LVL 48

Expert Comment

by:jpaulino
ID: 21764667
Using late binding is the best I can!

What better then a easy solution ? :)

Glad I could help
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Edureka is one of the fastest growing and most effective online learning sites.  We are here to help you succeed.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now