Posted By: hermes (hermes) on 'CZprogram'
Title: Re: VBA
Date: Wed Dec 12 07:57:02 2001
> Tak k tomu me napada:
> 1) bud do stringu pridavej oznaceni jednotl. radku - potom to jednoduse
> oznacis pomoci Range(MyStringWithRows).Select
>
> 2) nebo budes mit objekt typu Range, do ktereho budes vzdy pricitat dalsi
> Range pomoci metody Union. Jak na to (vypis z helpu excelu):
>
> Dim r1 As Range, r2 As Range, myMultiAreaRange As Range
> Worksheets("sheet1").Activate
> Set r1 = Range("A1:B2")
> Set r2 = Range("C3:D4")
> Set myMultiAreaRange = Union(r1, r2)
> myMultiAreaRange.Select
>
>
> No problem...
Diky. Neco takoveho jsem potreboval.
H E R M E S