Hi,

I am automating Excel using VB6 and I am having a problem inserting a row
(copying row) that contains a simple formula (Sum of two columns). The
inserts is working fine except it is not bringing over the formula. Any
ideas (see code below)?

wbExcel.Sheets(3).Rows(51).Insert

or

Set wr = wbExcel.Sheets(3).Range(A51).EntireRow()
Call wr.Insert(, False)

Thanks