RANGE
"Excellaro" ha scritto nel messaggio
...
I have in column B list of towns ad in in column A the state of the town
For example
TEXAS Dallas
Germany Berlin
Germany Bonn
Germany Stuttgart
How can i select all the rows where is it Germany?
rngStart = Cells.find("Germany").activate
Do while true
if activecell < Germany then
rngEnd = activecel..offset(...waht u want)
exit do
endif
loop
|