Posted to microsoft.public.excel.programming

george

external usenet poster

Posts: 3

Insert Row Problem

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Insert Object Problem	Raj	Excel Discussion (Misc queries)	1	April 20th 10 05:18 PM
insert row problem	WYN	Excel Discussion (Misc queries)	3	June 30th 05 05:46 AM
Insert\Name\Apply.... problem	David	Excel Worksheet Functions	6	February 25th 05 12:49 PM
Insert Code Problem	pwz	Excel Programming	2	July 7th 04 05:49 AM
copy insert problem	saziz[_10_]	Excel Programming	4	June 25th 04 01:50 AM

All times are GMT +1. The time now is 09:47 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us