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 |
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 |