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

Search the boards