[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 282: Undefined array key "app_rebranding_id"
[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 283: Undefined array key "app_url_scheme"
[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 284: Undefined array key "app_icon_url"
[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 285: Undefined array key "app_name"
[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 287: Undefined array key "app_alert_message"
[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 289: Undefined array key "app_android_id"
[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 290: Undefined array key "app_android_description"
[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 291: Undefined array key "app_banner_message_android"
[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 294: Undefined array key "app_ios_id"
[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 295: Undefined array key "app_ios_description"
[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 296: Undefined array key "app_banner_message_ios"
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4150: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3035)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4150: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3035)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4150: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3035)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4150: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3035)
Foros Ingeniería Civil • Condicional con una búsqueda. No sé cómo escribirlo
Página 1 de 1

Condicional con una búsqueda. No sé cómo escribirlo

Publicado: Jue Ago 06, 2009 9:55 am
por tetriak
Hola de nuevo, he abierto otro mensaje porque son dos cosas diferentes:

Quisiera hacer una macro que me encuentre la palabra "dato1" en una hoja, y si la encuentra que continue la macro ya hecha, sino encuentra la palabra "dato1", que pase a otra búsqueda, la de la palabra "dato2".

He conseguido hacer la búsqueda del nombre, pero la macro sólo me funciona cuando existe ese nombre, y sino, me da error.



Cells.Find(What:="dato1", After:=ActiveCell, LookIn:= _

xlFormulas, lookat:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _

xlNext, MatchCase:=False, SearchFormat:=False).Activate



Sabríais cómo hacerlo?

muchas gracias