RE: Excel makro

From: Likavcan, Alexander (Alexander.Likavcan@volkswagen.sk)
Date: 21. 05. 2002, 14:46 CEST

Previous message: Petr Kudrhalt: "Re: ADSL od Telecomu"
Maybe in reply to: Simona Trneckova: "Excel makro"
Next in thread: Simona Trneckova: "Re: Excel makro"
Reply: Simona Trneckova: "Re: Excel makro"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Zdar a silu Simona, dna 21.05.2002 si napisal(a):

> Dobry den
> prosim o radu s timto makrem: Ten radek : ActiveCell.FormulaR2C2 =
> "=VLOOKUP(RC[8],'sap (2)'!C[-1]:C[8],6,0)" se mi blokuje, pry "Object
> doesn't
> support this property or method (Error 438)", ale kdyz pracuje tenhle:
> ActiveCell.FormulaR1C1 = "=VLOOKUP(rc[8],ZAK!c[0]:c[1],2,FALSE)"
>  tak sakrys cem je problem?

sorry mozno sa mylim, ale kde si zobrala to formulaR2C2 ????
pokial viem tak excel tym R1C1 hovori: TATO BUNKA je stred vesmiru
odtialto rataj vzdialenosti ku inym bunkam (riadkom a stlpcom)
ale properties R2C2 som este nevidel .....

s pozdravom
AleXXX
-- 

Remember: there are no strangers in the world,
only friends who have not yet met.

Previous message: Petr Kudrhalt: "Re: ADSL od Telecomu"
Maybe in reply to: Simona Trneckova: "Excel makro"
Next in thread: 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 : 21. 05. 2002, 14:46 CEST