Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem to calculate cells
Hi,
I have a macro wicht is putting in a cell a formula vlookup(....). But Excel does not calculate it, I have a #Name error until I click on it. I have ask excel to calculate the cell but it doe not change anything. I am working with Excel 2000. Is it a bug of excel 2000 or is there a way to obtain than excel calculate it ? Thanks for any help and happy new year. Benjamin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem to calculate cells
Please show us the code that you are using.
the error you give suggests a typing mistake -----Original Message----- Hi, I have a macro wicht is putting in a cell a formula vlookup(....). But Excel does not calculate it, I have a #Name error until I click on it. I have ask excel to calculate the cell but it doe not change anything. I am working with Excel 2000. Is it a bug of excel 2000 or is there a way to obtain than excel calculate it ? Thanks for any help and happy new year. Benjamin . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem to calculate cells
oki
This is a simplified code but I have the same problem : In A1 put "poui" in F1 put "poui", in F2 put "grr" in G1 put 1 in G2 put 2 the code: public sub maisquestcequisepasse() range("B1").select activecell.formulaR1C1 ="=vlookup(RC[-1],F:G,2,false) end sub I just think I may have find it: VBA does not understand F:G........ GRRR I am stupid !!!!!!!!!!!!!!!!!!!! Thanks for help Patrick and have a nice year Benjamin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem with a function to calculate weighted test score | Excel Worksheet Functions | |||
UDF To Calculate Work hours between two dates Problem with code | Excel Discussion (Misc queries) | |||
calculate problem in excel | Excel Worksheet Functions | |||
HOW NOT TO CALCULATE CELLS IF ONE CONTAINS "0" | Excel Worksheet Functions | |||
excel calculate problem, (try to refer to defined names?) | Excel Programming |