working with Ranges in VBA

[kiransalu]

I have a sheet called "Data". I am filling this sheet (2 columns Fund name and Fund ID) from Oracle DB. Everyweek there is an increase in the funds list in DB. So i have to refresh the sheet from oracle. I have also a dropdown which has input range (Fund Name) from the data sheet.

Input Range = "A1:A230". Everyweek funds list increase by one or two rows in the data sheet. How do i dynamically set the input range as A1:A231,A1:A240 etc based on my last row in the sheet.

Early help is highly appreciated.

 

[SkipVought]

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

Please search FAQs et al before posting questions.

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!}