Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select range from a value
Hi
If i in collumn a have dates This i can order by dates so far so god A date can bee the same several times Now I whant to have a Combobox With The dates in from cllumn A I can that, but if the date are there maybe 10 times i get the dates in my combobox 10 times I only what to see it One time ( In SQL i use Disinct) When i have this date and choose the date in the combobox i want to see the range the value are in Like if i choose "12-12-2006" and have this value in A20 to A25 then i want to see this "$a$20:$a:$25" Hoipe some one can help me with this. Regards Alvin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can change range to select active rows instead of :=Range("S10 | Excel Discussion (Misc queries) | |||
When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
select range and put range address in variable | Excel Programming | |||
Compare a selected Range with a Named range and select cells that do not exist | Excel Programming | |||
Select Sheet then Select Range | Excel Programming |