Posted to microsoft.public.excel.programming

external usenet poster

Posts: 9

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can I use named range in data range box when creating pie chart?	BJackson	Charts and Charting in Excel	2	August 17th 05 05:37 PM
Creating range name for a range selection	Mervyn Thomas	Excel Programming	1	January 26th 04 05:18 PM
Creating a range	Marco Roberto	Excel Programming	3	January 22nd 04 06:48 PM
Creating a Range object in .Net	Gary[_14_]	Excel Programming	0	January 6th 04 10:46 PM
Creating an XL Range on the fly	Chris Parker	Excel Programming	3	August 19th 03 01:09 PM

All times are GMT +1. The time now is 02:24 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us