RE: koniec tabulky

From: Likavcan, Alexander (Alexander.Likavcan@volkswagen.sk)
Date: 31. 05. 2002, 10:10 CEST


Zdar a silu Milan, dna 31.05.2002 si napisal(a):

> Potrebujem sa dostat makrom v excelovskej tabulke
> na uplne posledny riadok do stlpca A.
> Tato bunka je prazdna (a aj cca 50-60 buniek nad nou),
> ale v inych stlpcoch su natiahnute nejake veci.
> 
> Toto
>     ActiveCell.SpecialCells(xlLastCell).Select
hod tam druhy riadok:
 ActiveCell.Offset(0, -(ActiveCell.Column - 1)).Range("A1").Select

s pozdravom
AleXXX
-- 

Remember: there are no strangers in the world,
only friends who have not yet met.



This archive was generated by hypermail 2.1.2 : 31. 05. 2002, 10:10 CEST