Posted to microsoft.public.excel.programming

Ram

external usenet poster

Posts: 138

using VB to enter a sumproduct formula in a cell

I would like help with the following syntax error:

Private Sub worksheet_Activate()
If Not ActiveSheet.Previous Is Nothing Then
Me.Range("B2").Formula =
"=SumProduct(--(Sheets("Sheet4").Range(A1:A30000) = Sheets(Processd
Amount).Range(B1)),--(Sheets(Sheet4).Range(AL1:AL30000) 0))"
End If
End Sub

also is there a way to enter the value of the above formula instead of the
formula?

Thanks for all your help

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
How to enter a formula in a cell?	novastar	Excel Worksheet Functions	2	September 1st 09 09:25 PM
Cannot enter formula in a cell after removing a circular formula	Big Corona	Excel Worksheet Functions	0	April 5th 05 06:07 PM
Trying To Enter A Formula Into Every Cell In A Column.	Mag1c1an	Excel Programming	5	January 3rd 05 04:50 PM
Enter formula in cell	James Stephens	Excel Programming	3	January 22nd 04 05:26 PM
Enter Formula in a cell with VBA	Bruce Roberson	Excel Programming	2	July 31st 03 08:54 PM

All times are GMT +1. The time now is 08:03 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us