Re: vba excel

From: pp21@mail.cz
Date: 13. 01. 2002, 14:27 CET

Previous message: pp21@mail.cz: "Re: Nejsou videt "Okolni pocitace""
In reply to: Lukas Strmiska: "vba excel"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

> Byl bych velice vdecny za kompletni kod prikladu jak zapsat
> hodnotu "5" do bunky "A1" v "List1".

Sub Zapis_5()
  ThisWorkbook.Sheets("List1").Range("A1").Value = 5
End Sub

Tohle zapise do tu hodnotu do sesitu, ve kterem je ulozene to makro.
Pokud to chces do jineho, musis misto ThisWorkbook pouzit
Workbooks("Sešit1"). Taky muzes pouzit ActiveWorkbook, pak se ta
hodnota vlozi do aktualniho sesitu.
Bacha na ty mnozny cisla v anglictine (book, books, window, wondows),
v tom se casto delaji chyby.

Taky muzes pouzit ActiveSheet misto Sheets("List1"), nebo taky
ActiveCell.FormulaR1C1 misto Range("A1").Value (pak ale musis vyhodit
workbook a sheet).


PS: na zkoumani je dobry pustit si "zaznam makra" a pak se v tom
vysledku postourat, ledacos se z toho dozvis.

-pp21-

Previous message: pp21@mail.cz: "Re: Nejsou videt "Okolni pocitace""
In reply to: Lukas Strmiska: "vba excel"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

This archive was generated by hypermail 2.1.2 : 13. 01. 2002, 14:27 CET