How to insert a complex formula in a cell with VBA

mircea

Posts: n/a

How to insert a complex formula in a cell with VBA

How to insert a formula in a cell with VBA
example : if formula is "=if(a3=2;a3;a2)"
i used
cells(2,3).Formula="=if(a3=2;a3;a2)"

bu i receive an error
Application object ....

if i used "=s4"
everything is ok.

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
inserting data from a row to a cell, when the row number is specified by a formula in a cell	[email protected]	New Users to Excel	2	January 6th 05 07:18 AM
using content of a cell in a formula in another cell	mpierre	Excel Worksheet Functions	3	December 28th 04 03:43 PM
How can I write an if-then formula for 0 or less than 0 in cell t.	Baz1	Excel Worksheet Functions	1	November 30th 04 04:33 PM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM
Cell doesn't show formula result - it shows formula (CTRL + ' doe.	o0o0o0o	Excel Worksheet Functions	6	November 19th 04 03:13 PM

All times are GMT +1. The time now is 12:41 PM.

Menu

About Us