Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hey, could anyone helpme to find out what is wrong with this code?
'write the quatity of hours we have to deliver special gases Windows("anc.xls").Activate Range("I2").Select ActiveCell.FormulaR1C1 = "=IF(ISERROR(VLOOKUP(RC[-7],'[Prazos de entrega_matriz.xls]GE'!R2C1:R93C3,3,FALSE)),"",VLOOKUP(VLOOKUP(RC[-7],'[Prazos de entrega_matriz.xls]GE'!R2C1:R93C3,3,FALSE),'[Tabela Prazos de Entrega - Anchieta.xls]Prazo de entrega'!R13C1:R16C4,4,FALSE)*24)" Range("I2").Select Selection.Copy Range("L2").Select Range(Selection, Selection.End(xlDown)).Select Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False Application.CutCopyMode = False Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Wrong code? | Excel Programming | |||
what is wrong with this code? | Excel Programming | |||
What's wrong with this code? Please help. | Excel Programming | |||
What's wrong with this code, please? | Excel Programming | |||
What's wrong with this bit of code | Excel Programming |