Solved

late Binding command to delete a cell in excel using VB2005

Posted on 2008-06-11
5
240 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

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…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

856 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