Re: Excel makro

From: Simona Trneckova (strnecka13@seznam.cz)
Date: 20. 05. 2002, 14:14 CEST

Previous message: mail@pp21.cz: "Re: Kupirujte ocasy!"
In reply to: mail@pp21.cz: "Re: Excel makro"
Next in thread: Simona Trneckova: "Re: Excel makro"
Next in thread: Likavcan, Alexander: "RE: Excel makro"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

No, nejde to ani tak. Navratova hodnota je #NAME?
a myslim, ze jsem to opsala spravne :

Sub zak()
'
' zak Macro
'
'
    ActiveCell.FormulaR1C1 = "=VLOOKUP(I1,ZAK!A:B,2,FALSE)"
    
End Sub

Me vlastne by to zajimalo obecne. Jak prilepit makrem predem definovanou
formuli? Jakoukoli....


> misto stredniku pouzij carku, takhle:
> 
> ActiveCell.FormulaR1C1 = "=VLOOKUP(I1,ZAK!A:B,2,FALSE)"
> 
 

______________________________________________________________________
Reklama:
E-mail zdarma na cely zivot: http://email.seznam.cz

Previous message: mail@pp21.cz: "Re: Kupirujte ocasy!"
In reply to: mail@pp21.cz: "Re: Excel makro"
Next in thread: Simona Trneckova: "Re: Excel makro"
Next in thread: Likavcan, Alexander: "RE: Excel makro"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

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