Solved

late Binding command to delete a cell in excel using VB2005

Posted on 2008-06-11
5
234 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
Comment Utility
Hi MichMat,

Try:

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

Author Comment

by:MichMat
Comment Utility
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
Comment Utility
Ok, try this:

objSheetsH.Range("F4").Delete
0
 

Author Closing Comment

by:MichMat
Comment Utility
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
Comment Utility
Using late binding is the best I can!

What better then a easy solution ? :)

Glad I could help
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

763 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

6 Experts available now in Live!

Get 1:1 Help Now