Re: Excel makro

From: mail@pp21.cz
Date: 20. 05. 2002, 13:50 CEST

Previous message: Honza: "Re: Kupirujte ocasy!"
In reply to: Simona Trneckova: "Re: Excel makro"
Next in thread: Simona Trneckova: "Re: Excel makro"
Reply: Simona Trneckova: "Re: Excel makro"
Reply: Simona Trneckova: "Re: Excel makro"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

>  ActiveCell.FormulaR1C1 = "=VLOOKUP(I1;ZAK!A:B;2;FALSE)"
>  ActiveCell.Calculate

> Tak to nebere...

misto stredniku pouzij carku, takhle:

ActiveCell.FormulaR1C1 = "=VLOOKUP(I1,ZAK!A:B,2,FALSE)"

jo a to Calculate muzes klidne vypustit, pokud teda
nemas nasteveny rucni prepocitavani.

-pp21-

Previous message: Honza: "Re: Kupirujte ocasy!"
In reply to: Simona Trneckova: "Re: Excel makro"
Next in thread: Simona Trneckova: "Re: Excel makro"
Reply: Simona Trneckova: "Re: Excel makro"
Reply: Simona Trneckova: "Re: Excel makro"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

This archive was generated by hypermail 2.1.2 : 20. 05. 2002, 13:51 CEST