No No what I means is that using VBA I need to get the Data Validation Drop-Down till the Rows of the Column C..

Example from your code, the 11 in the Last part of the below code I need to have it as a variable in such a way that the value is always the Last Filled Cell in the Column C like Counta($C:$C)

PHP Code: 
Target.Column = 8 And (Target.Row >= 2 And Target.Row <= 11) Then 
Changed to

PHP Code: 
Target.Column = 8 And (Target.Row >= 2 And Target.Row <= LastRow) Then 
where LastRow is variable Defined to store the COunta($C:$C) , however I dont know how to do that..?

I think I will manage this now..

Thanks DGagnon, I will require some more help in my new thread..

Warm REgards
e4excel