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
MichMatAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Jorge PaulinoConnect With a Mentor IT Pro/DeveloperCommented:
Ok, try this:

objSheetsH.Range("F4").Delete
0
 
Jorge PaulinoIT Pro/DeveloperCommented:
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
 
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
 
Jorge PaulinoIT Pro/DeveloperCommented:
Using late binding is the best I can!

What better then a easy solution ? :)

Glad I could help
0
All Courses

From novice to tech pro — start learning today.