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