RE: koniec tabulky

From: Trejbal Jindřich Ing (Trejbal.J@gealvz.cz)
Date: 31. 05. 2002, 09:48 CEST

Previous message: mikisov m: "problem s lpt"
Maybe in reply to: Milan Kevely: "koniec tabulky"
Next in thread: Milan Kevely: "RE: koniec tabulky"
Next in thread: Likavcan, Alexander: "RE: koniec tabulky"
Reply: Milan Kevely: "RE: koniec tabulky"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

    ' nalezení prvního prázdného řádku
    nextrow = _
    Application.WorksheetFunction.CountA(Range("A:A")) + 1


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
ma teraz hodi do "M13526".

Ako sa dostanem v tom istom riadku do stlpca A, ked
koniec tabulky _nie_je_ vzdy v stlpci M?
Posun o urcity pocet buniek dolava teda pouzit nemozem.
Pocet riadkov je tiez vzdy iny...

Poradte, moc to suri :-( .

Milan Kevely 
milank@softhome.net 
icq 153425125

Previous message: mikisov m: "problem s lpt"
Maybe in reply to: Milan Kevely: "koniec tabulky"
Next in thread: Milan Kevely: "RE: koniec tabulky"
Next in thread: Likavcan, Alexander: "RE: koniec tabulky"
Reply: Milan Kevely: "RE: koniec tabulky"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

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