View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
grigoras victor
 
Posts: n/a
Default how can I select a range of cells based on a value of a cell?

I import an excel table from another application.I want to make a macro to:
1.sort table -it'easy
2.from sorted table to select a range of cells until a value from sorted
table is matched.This is the problem.
3.copy selected range in another sheet-it's easy.
Thanks,