Re: makro pro excel

From: Kamil Sverak (sverak@csadbk.cz)
Date: 26. 02. 2003, 08:44 CET

Next message: Peter Marko: "RE: Wget problem"

Previous message: Jaroslav Dravecky: "Re: sk-nic"
In reply to: David Lehner: "makro pro excel"
Next in thread: David Lehner: "Re: makro pro excel"
Reply: David Lehner: "Re: makro pro excel"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

> mam makro ktere prenasi text z jedne bunky do druhe

> Sheets("seznam").Cells(10, "w").value = Range("poznamka")

> ale toto mi prenese pouze text ktery nema vice jak 255 znaku.

> Cim muzu toto nahradit ?
 
napadaji me dve moznosti:
1. pouzit promenou.
   pozn = Range("poznamka")
   Sheets("seznam").Cells(10, "w").value = pozn
2. odkazat primo na poznamku
   Sheets("seznam").Cells(10, "w").value = "=poznamka"

-- 
cao,
 Kamil

Next message: Peter Marko: "RE: Wget problem"

Previous message: Jaroslav Dravecky: "Re: sk-nic"
In reply to: David Lehner: "makro pro excel"
Next in thread: David Lehner: "Re: makro pro excel"
Reply: David Lehner: "Re: makro pro excel"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

This archive was generated by hypermail 2.1.6 : 26. 02. 2003, 08:43 CET