Excel: Macro to set validation data list

[azzi2000]

This is what I am trying to accomplish:
--- pseudocode
Define RangeRate Where ColumnA = Rate1 (next loop Rate2..)
Range("A6").select
Set the validation List based on RangeRate
----
Column1,Column2
Rate1, 5/1, 4
Rate1, 5/2, 4.5
Rate1, 15 , 5.8
... might have more column with Rate1
...
Rate2, 5/1, 4.2
Rate2, 5/2, 4.7
Rate2, 15 , 6.2

Please advice,
Thank you,
Dré

 

[SkipVought]

Dré,

How can I rename a table as it changes size faq68-1331




Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}