Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Im trying and trying but it wont work.
I want to give a cell a function and want to do this with the help of a macro. But everytime VB gives an error. I now have this lines in VB: Sheets("01").Select Columns("A:A").Select Range("A33").Select ActiveCell.FormulaR1C1 = "HERE BEGINS THE FUNCTION!!" "=IF(ISERROR(VLOOKUP('I:\300\390\391\numbers\2 003 halfjaar\Cijfers\ExportenMonarch\[exportmonarch_bankiersDeb etHJ2003.xls]Bankiers_debet'!A1,'I:\300\390\391 \Jaarrekening\2002 jaar\Cijfers\ExportenMonarch\[exportmonarch_bankiersDebet20 02.xls]Bankiers_debet'!$A$1:$A$50,1,FALSE)),'I:\300\390\3 91 \Jaarrekening\2003 halfjaar\Cijfers\ExportenMonarch\[exportmonarch_bankiersDeb etHJ2003.xls]Bankiers_debet'!$A1,0)" The error is "runtime error 1004" "Application defined or object-defined error" Is the function to long or something?? How can i solve this? thanks thomas .. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Give me a Function | Excel Worksheet Functions | |||
function to give me cell reference | Excel Worksheet Functions | |||
Record a macro to use in any workbook--give it to others. | Excel Discussion (Misc queries) | |||
Function to give value of a BLANK cell based on another | Excel Worksheet Functions | |||
How to give function by cell color to sum two value in Excel | Excel Worksheet Functions |