nenajdena bunka v exceli

From: Milan Kevely (milank@softhome.net)
Date: 21. 06. 2002, 09:46 CEST

Previous message: joot@volny.cz: "zjisteni MAC adresy sitovky"
Next in thread: Likavcan, Alexander: "RE: nenajdena bunka v exceli"
Reply: Likavcan, Alexander: "RE: nenajdena bunka v exceli"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Mam v makre nieco taketo:
    Rows("1:1").Select
    Selection.Find("XYZ", After:=ActiveCell).Activate

Bunka s touto hodnotou moze byt vzdy v inom stlpci...
Neviem urobit ak bunka s touto hodnotou v prvom riadku
nie je, elegantny skok niekam inam...
Nechcem aby to koncilo chybovou hlaskou makra.

Nieco ako:
if not exist ... "XYZ hocikde v riadku" GoTo NIEKAM

Ako to urobit?

Milan Kevely 
milank@softhome.net 
icq 153425125

Previous message: joot@volny.cz: "zjisteni MAC adresy sitovky"
Next in thread: Likavcan, Alexander: "RE: nenajdena bunka v exceli"
Reply: Likavcan, Alexander: "RE: nenajdena bunka v exceli"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

This archive was generated by hypermail 2.1.2 : 21. 06. 2002, 09:47 CEST