Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Rangeusing WindowsXP professional and excel 2003 (excel is in Italian) as I
am writing from Rome Italy and I need some help: What I need is to in put a formula (if,true, false) in the cells of my excel. the the macro I have used is: Worksheets("output").Range("B17")="=SE(O_(B17="";D 17="";D17=0);"";CERCA.VERT(B17;input!$A$3:$B$1000; 2;FALSO)*D17)" I get an error (runtime 1004) I do not know if it due to the fact that VBA macro doesn't recognice the instruction in italian in the formula ) Traslation:( SE= IF, CERCA.VERT= SEARCH Vertical) I tried to use IF and VLOOKUP in place of the italian but got same error Please can any one help me? Thanks a lot Francesco |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Selecting Last Sheet | Excel Worksheet Functions | |||
apply a macro to all sheets except for a certain sheet | Excel Discussion (Misc queries) | |||
point to one number on each sheet that will be in many formulas | New Users to Excel | |||
AUTO FILTER NOT CHANGING RESULTS | Excel Discussion (Misc queries) | |||
Macro, select Sheet "Number", NOT Sheet Name | Excel Worksheet Functions |