Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 245
  • Last Modified:

late Binding command to delete a cell in excel using VB2005

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
MichMat
Asked:
MichMat
  • 3
  • 2
1 Solution
 
jpaulinoCommented:
Hi MichMat,

Try:

objSheetsH.Rows(4).Delete(-4162)
0
 
MichMatAuthor Commented:
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
 
jpaulinoCommented:
Ok, try this:

objSheetsH.Range("F4").Delete
0
 
MichMatAuthor Commented:
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
 
jpaulinoCommented:
Using late binding is the best I can!

What better then a easy solution ? :)

Glad I could help
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now