RANGE

  • Thread starter Thread starter Excellaro
  • Start date Start date
E

Excellaro

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?
 
Perhaps try Data|Filter|AutoFilter -> Select Germany from the drop down. This
will hide everything that is not Germany...
 
Excellaro said:
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?
Click to expand...
rngStart = Cells.find("Germany").activate
Do while true
if activecell <> Germany then
rngEnd = activecel..offset(...waht u want)
exit do
endif
loop
 
Back
Top