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