Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Formulae in Macros
Hi guys, can anyone help me with this problem i have, i'm using th folling formula: =SUM(IF(('Full Table'!$AF$2:$AF$6000="Baby Care")*('Ful Table'!$AG$2:$AG$6000="Goods"),'Full Table'!$AE$2:$AE$6000)) To get this formula to work though i have to do CTRL SHIFT and ENTER. The problem is i like to use my formulae in my macros so theres never formula just sitting in the workbook to try and save on space using th following command line: Worksheets("Full Table").Range("H2").Value = _ "=IF(ISERROR(VLOOKUP(G2,Requisitioners!$A$2:$E$155 ,2,FALSE)),"""",(VLOOKUP(G2,Requisitioners!$A$2:$E $155,2,FALSE)))" But if i try this command with the above formula it doesn't wor because of the CTRL SHIFT ENTER and if i try using {} around th formula it doesn't work either. Can someone please help me with this please? Cheers, Donni. :confused -- DDONN ----------------------------------------------------------------------- DDONNI's Profile: http://www.excelforum.com/member.php...fo&userid=1544 View this thread: http://www.excelforum.com/showthread.php?threadid=27207 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Formulae in Macros
Worksheets("Full Table").Range("H2").FormulaArray =
-- Regards, Tom Ogilvy .. "DDONNI" wrote in message ... Hi guys, can anyone help me with this problem i have, i'm using the folling formula: =SUM(IF(('Full Table'!$AF$2:$AF$6000="Baby Care")*('Full Table'!$AG$2:$AG$6000="Goods"),'Full Table'!$AE$2:$AE$6000)) To get this formula to work though i have to do CTRL SHIFT and ENTER. The problem is i like to use my formulae in my macros so theres never a formula just sitting in the workbook to try and save on space using the following command line: Worksheets("Full Table").Range("H2").Value = _ "=IF(ISERROR(VLOOKUP(G2,Requisitioners!$A$2:$E$155 ,2,FALSE)),"""",(VLOOKUP(G 2,Requisitioners!$A$2:$E$155,2,FALSE)))" But if i try this command with the above formula it doesn't work because of the CTRL SHIFT ENTER and if i try using {} around the formula it doesn't work either. Can someone please help me with this please? Cheers, Donni. -- DDONNI ------------------------------------------------------------------------ DDONNI's Profile: http://www.excelforum.com/member.php...o&userid=15443 View this thread: http://www.excelforum.com/showthread...hreadid=272070 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Formulae in Macros
Hi
try: Worksheets("Full Table").Range("H2").formulaarray= _ "=IF(ISERROR(VLOOKUP(G2,Requisitioners!$A$2:$E$155 ,2,FALSE)),"""",(VLOOKUP(G2,Requisitioners!$A$2:$E $155,2,FALSE)))" "DDONNI" wrote: Hi guys, can anyone help me with this problem i have, i'm using the folling formula: =SUM(IF(('Full Table'!$AF$2:$AF$6000="Baby Care")*('Full Table'!$AG$2:$AG$6000="Goods"),'Full Table'!$AE$2:$AE$6000)) To get this formula to work though i have to do CTRL SHIFT and ENTER. The problem is i like to use my formulae in my macros so theres never a formula just sitting in the workbook to try and save on space using the following command line: Worksheets("Full Table").Range("H2").Value = _ "=IF(ISERROR(VLOOKUP(G2,Requisitioners!$A$2:$E$155 ,2,FALSE)),"""",(VLOOKUP(G2,Requisitioners!$A$2:$E $155,2,FALSE)))" But if i try this command with the above formula it doesn't work because of the CTRL SHIFT ENTER and if i try using {} around the formula it doesn't work either. Can someone please help me with this please? Cheers, Donni. -- DDONNI ------------------------------------------------------------------------ DDONNI's Profile: http://www.excelforum.com/member.php...o&userid=15443 View this thread: http://www.excelforum.com/showthread...hreadid=272070 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulae: Paste value formulae after doing an average operation | Excel Discussion (Misc queries) | |||
why does Excel see my simple formulae as macros now? | Excel Worksheet Functions | |||
Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions | |||
convert lotus 123w macros to excel macros | Excel Programming | |||
Macros to hide/protect formulae | Excel Programming |