Hi Fernando

can we take it one step further - why are you trying to do this with a macro
.... is it part of a larger macro, is it to copy the information to another
sheet or just to print it
because personally i'ld use either data / filter / autofilter from the menu
to do this or use the autofilter in code rather than find

Cheers
JulieD

"Fgomez" wrote in message
...
I have a file with Column A, containing accounts number and to the right, 7
columns with different information related to the accounts, each account
could have 1 to hundreds of rows, what I am trying to do is with a Macro
use
"Find" function and look for a specific account but the account to be
input
in message box.
I try to do it with the Macro record but I can only get a specific
account.
Could I have some help.

Thanks

Fernando