Thread: creating range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
toon toon is offline
external usenet poster
 
Posts: 9
Default creating range

hi!

i want to create a (dynamic) range in a row of sorted values

eg 99 97 97 97 96 95 94 91 90 89 ...

MyRange1 = all the cells 95
MyRange2= all the cells less than 95, greater than 90
Myrange3= ....

how do i manage?