Link to home
Start Free TrialLog in
Avatar of MichMat
MichMat

asked on

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
Avatar of Jorge Paulino
Jorge Paulino
Flag of Portugal image
Hi MichMat,

Try:

objSheetsH.Rows(4).Delete(-4162)
Avatar of MichMat
MichMat

ASKER

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
ASKER CERTIFIED SOLUTION
Avatar of Jorge Paulino
Jorge Paulino
Flag of Portugal image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of MichMat
MichMat

ASKER

I was expecting a more complicated answer for the solution of the problem ....... ahh well I'll just have to take the simple one :)
Avatar of Jorge Paulino
Jorge Paulino
Flag of Portugal image
Using late binding is the best I can!

What better then a easy solution ? :)

Glad I could help